Difference between revisions of "SQL Browser"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 9: Line 9:
:* Clicking the arrow next to one expands the tree, showing the columns in the table
:* 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 (<tt>SELECT *</tt>) from that table.  
:* Double-clicking a table populates the statement pane with a default query (<tt>SELECT *</tt>) from that table.  
:* Clicking the triangle-button on the right runs the query.  
:* To run the query, press <tt>Ctrl+Enter</tt> or click the triangle-button on the right.  
:: [[File:SQLBrowserGoButton.png]]
:: [[File:SQLBrowserGoButton.png]]



Revision as of 23:19, 18 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:

__TBD: Retake this screenshot__
SQLBrowserSelect.png
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.
  • To run the query, press Ctrl+Enter or click the triangle-button on the right.
SQLBrowserGoButton.png
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