Difference between revisions of "SQL Browser"

Revision as of 20:24, 14 November 2011

Designer > Data > Objects > [SQL Browser]

The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:

How it works

The navigation pane on the left shows all of the Object tables in your database.
Clicking the arrow next to one expands the tree, showing the columns in the table
Double-clicking a table populates the statement pane with a default query (SELECT *) from that table.
Clicking the triangle-button on the right runs the query.

Considerations

SQL syntax is not case-sensitive, except for table names and field names.
When you double-click an Object table, backticks are (`) added around the table name in the SQL expression.

They're needed when the table name turns out to be in the (fairly lengthly) list of SQL Reserved Words.

For example:

SELECT * FROM `ORDER`

Without the backticks, you get an error like this:

Encountered "Order" at line 1, column 15. Was expecting (...

which means that parser found a word it recognized, but didn't find other things it expected before it got to that word.

Learn more: SQL Syntax

@@ Line 14: / Line 14: @@
 ;Considerations:
 :* SQL syntax is not case-sensitive, except for table names and field names.
-:* It's a good idea to enclose table names in back-ticks (<tt>`</tt>), in case the table name
+:* When you double-click an Object table, backticks are (<tt>`</tt>) added around the table name in the SQL expression.
-:: turns out to be in the (fairly lengthly) list of [[SQL Reserved Words]].
+:: They're needed when the table name turns out to be in the (fairly lengthly) list of [[SQL Reserved Words]].
 :: For example:
 ::: <tt>SELECT * FROM `ORDER`</tt>
-:: (When you double-click a table name, the backticks are added for you.)
+:: Without the backticks, you get an error like this:
+:::<tt>Encountered "Order" at line 1, column 15. Was expecting (...</tt>
+::which means that parser found a word it recognized, but didn't find other things it expected before it got to that word.
 ''Learn more:'' [[SQL Syntax]]