View Data Trivia
By jfbrown on Jan 25, 2006
View data is a simple window that allows you to run sql, any sql, even multiple statements. It has some undocumented commands you may or may not find useful. Here they are.
title something meaningful
Ever had more than one View Data document open and forgotten what's in which one? This allows you to change this document's title.
setautocommit on | off
Default is on. If you wish to run multiple statements in a single transaction, turn it off
If you're writing a long script, add comments using this format.
For troubleshooting, check out:
This shows the driver provided pre-execution ResultSet metadata from a preparedStatement.getMetaData() call for the provided select statement. An exception here means your 3rd party driver is not supported and just won't work at design time.
Show the DataBaseMetaData; see Connection.getMetaData().
table table_name | schema.table_name
Shows the meta data for a particular table.
For each open project, list the data sources it uses and their config info.
And lastly, a feature I didn't quite finish:
useViewData on | off
When on, selecting any RowSet and right-click "Edit SQL Statement" will open the sql statement in a View Data Window (with a Save button) instead of the Query Editor. To return to using the Query Editor, set this to off or restart the IDE. What's missing: running when there are parameters (?) in the query is not supported.