Monday, August 26, 2024
Tip of the Day: Capturing SELECT Statements from Queries
Product.......: R:BASE 11
Build.........: 11.0.1.40815 or higher
Section.......: Query Builder/Query Wizard
Keywords......: Continuation Character, SELECT, SQL, Settings
Did you know that when capturing SELECT statements from queries, the continuation/plus character (+) may be inserted to recycle SQL code easily?
The Query Builder and Query Wizard both include a new "Continuation Characters" setting where the + is inserted at the end of each line.
When defining queries in the Query Builder, the SELECT command syntax is provided in the lower panel and changes as the query definition changes. The text in the window is not editable but can be copied to the clipboard by selecting the "Copy Syntax" button on the Query Builder toolbar. Select "Query > Query Builder Settings" from the main menu bar to enable the "Continuation Characters" setting.
![]()
The SELECT command syntax is available for review in the lower panel of the Query Wizard when you click on the "SQL" tab. To ensure the statement is current, select the "Build SQL" menu option on the Query Wizard toolbar to refresh the SQL statement. The text in the window is not editable but can be copied to the clipboard by selecting the "Copy Query to Clipboard" button on the toolbar. The "Continuation Characters" setting check box is available within the "SQL" tab.
![]()
The continuation character is the character for the command line continuation, which tells the R:BASE engine parser that the code continues on the next line. The PLUS setting is used to assign the continuation character (default: +).
Enabling the Continuation Character setting is a time-saving feature when capturing code, especially in large views with advanced definitions!
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
Tip of the Day: Capturing SELECT Statements from Queries
Product.......: R:BASE 11
Build.........: 11.0.1.40815 or higher
Section.......: Query Builder/Query Wizard
Keywords......: Continuation Character, SELECT, SQL, Settings
Did you know that when capturing SELECT statements from queries, the continuation/plus character (+) may be inserted to recycle SQL code easily?
The Query Builder and Query Wizard both include a new "Continuation Characters" setting where the + is inserted at the end of each line.
When defining queries in the Query Builder, the SELECT command syntax is provided in the lower panel and changes as the query definition changes. The text in the window is not editable but can be copied to the clipboard by selecting the "Copy Syntax" button on the Query Builder toolbar. Select "Query > Query Builder Settings" from the main menu bar to enable the "Continuation Characters" setting.
The SELECT command syntax is available for review in the lower panel of the Query Wizard when you click on the "SQL" tab. To ensure the statement is current, select the "Build SQL" menu option on the Query Wizard toolbar to refresh the SQL statement. The text in the window is not editable but can be copied to the clipboard by selecting the "Copy Query to Clipboard" button on the toolbar. The "Continuation Characters" setting check box is available within the "SQL" tab.
The continuation character is the character for the command line continuation, which tells the R:BASE engine parser that the code continues on the next line. The PLUS setting is used to assign the continuation character (default: +).
Enabling the Continuation Character setting is a time-saving feature when capturing code, especially in large views with advanced definitions!
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/102342416.5303314.1724683729889%40email.ionos.com.
