View Data Trivia

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


// comment
If you're writing a long script, add comments using this format.




For troubleshooting, check out:


smd your_select_statement
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.


getmetadata
Show the DataBaseMetaData; see Connection.getMetaData().


table table_name | schema.table_name
Shows the meta data for a particular table.


datasources
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.



Comments:

sdsd

Posted by guest on March 22, 2006 at 02:11 AM PST #

Post a Comment:
Comments are closed for this entry.
About

jfbrown

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
News
Blogroll

No bookmarks in folder