I enter the Query:
SELECT A, B, C
FROM Table
AS Name
Then I save it and close it. When I re-open the Query, I get:
SELECT A, B, C FROM Table AS Name
This is very annoying with long Queries. Is there a setting somewhere to fix it?
Thanks for any help
Det
[Solved] Cannot save a carriage return in a Query
[Solved] Cannot save a carriage return in a Query
Last edited by robleyd on Fri Sep 21, 2018 2:16 am, edited 1 time in total.
Reason: Tagged [Solved] [robleyd, Moderator]
Reason: Tagged [Solved] [robleyd, Moderator]
OpenOffice 4.1.5 on Mac Sierra 10.13.1
Re: Cannot save a carriage return in a Query
Yes.det wrote:This is very annoying with long Queries. Is there a setting somewhere to fix it?
After you open and write your Query, before you save it, either:
- From the Menu: Edit -> Run SQL command directly
Make sure above has a check mark next to it - From the Toolbar:
Click on the icon: Run SQL command directly ( SQL command with a GREEN check mark )
- The above means, the Base Parser will NOT check the Query before running it, NOR before executing your Query. Therefore, you canNOT use the Query as a Parameter Query ( to prompt user for input before executing it ).
- Additionally, when a Query is saved to Run Directly, you CAN, if you want, add comments to the Query, by using two dashes. For example:
Code: Select all
-- This Query is to be saved and run directly withOUT the Base Parser being involved SELECT A, -- This column will display the information from A B, C FROM Table AS Name -- This is an example of the tables I want to use
Sliderule
Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.
Re: Cannot save a carriage return in a Query
Solved
Thanks so much for detailed explanation. Works perfectly.
Thanks so much for detailed explanation. Works perfectly.
OpenOffice 4.1.5 on Mac Sierra 10.13.1