|
|
 |
|
DataVision 2007 improves readability of SQL
text by providing clear color-coding and bolding of
keywords, function names, numbers, strings, table names
and more. This allows you to easily identify possible
mis-spelt words and naming conflicts. |
|
|
|
Just like the 'code-completion' in popular IDEs, DataVision
2007 provides advanced SQL completion of Table names
and Field names. You can have the SQL editor complete
the typing of a Table or Field name simply by typing a
few letters of the name and then pressing a special key
combination. If more than one name if possible from what
has been typed, then a 'Drop-down' list will display
allowing a selection to be made. |
|
|
|
In addition to 'Auto Completion', DataVision 2007
allows you to create custom SQL templates. These
templates can be inserted at any point with a couple of
key strokes. You can also specify where you would like
the cursor to be positioned in the template once it has
been inserted. |
|
A common task when developing SQL for databases or
programming tools is adding and removing code commands
and text formatting to the SQL so than it can be used in
code.
DataVision 2007's SQL Editor allows this
formatting to be added or removed with a single mouse
click. This formatting can be applied in two different
formats; Line and Text. The formatting can be customized
to suit any language. |
|
Example of 'Line' formating (Delphi style).
Example of 'Text' formatting (Delphi style).
|
|
Managing your SQL queries in DataVision 2007
is simple with it's easy folder structure. This allows
you to group related SQL queries together under
meaningful names. |
|
|
|
DataVision 2007's power and flexibility shine
through when running SQL queries. From simple
single-statement queries, to long multi-page scripts, DataVision
2007 allows you to create and execute these in a
direct and easy way.
When executing SQL in DataVision 2007, you not
only have the same powerful features of the DataGrid
used for viewing Tables, but you can view multiple
resultsets*, view execution statistics, and print and
save the results in an HTML report. |
|
Example of query messages 'HTML report'.
|
|
|
|
|
