dbWindow 3.0 removes all the stumbling blocks to using a database with MicroStation
The SQL Management system's dialog items are located in the top portion of the main dialog and include the SQL Description text item and list box, the SQL Statement multiline text item, and the Append, Input, Change, Remove, and Process push button items.
The SQL Management system gives the user a means of storing, retrieving, and then using the four major data editing SQL statements - select, insert, update, and delete.
There is no limit to the number of SQL statements that can be saved to a file and all four statement types can be saved to the same file. The file is simply a text file.
The first four operations found on the File pull-down menu operate on the SQL statement text file.
Upon opening an SQL file, the four kinds of statements (select, insert, update, and delete) are sorted into four lists which can be accessed by setting the corresponding marker on the SQL pull-down menu.
Each SQL statement can have an associated meaningful description or alias. This is a powerful feature for those who are unfamiliar with SQL syntax or just for quick retrieval of SQL statements.
And to make working with SQL even easier, you can build SQL Select statements with a clear user-friendly interface instead of typing it.
