SQL Source Format

Top  Previous  Next

SQL Source Format

 

UTB release version 3.0.0 has the option to display the SQL statement with quote " marks (The default) or with square brackets [ ].

 

This option is switched on / off in the Menu bar / Query / Use Brackets or Menu bar / Query / Use Quotes. If neither is checked then the syntax used is configured by the system and looks like quote " marks.

 

It is suggested that this option is left unaltered unless told to change it by Unity Solutions.

 

To change to square brackets [  ] select the option and the following warning is displayed.

 

Query_Display_format

Select No to exit the option or Yes to continue.

 

 

SQL_source_pane2

 

 

The default format is configured by the system and the Menu / Query drop down box will show neither option checked.

 

Once either option is checked and warning accepted, the next query will show the changes.

In the above example square brackets [ ] are defined and the Columns in the Sort and Criteria pane and in the SQL pane.

 

 

 

 



Page URL: http://www.unitysolutions.com/Helps/UTB/HTML/index.html?sql_source_format.htm