dbWindow 3.0 removes all the stumbling blocks to using a database with MicroStation
Through the combined use of the grid item and the commit button dbWindow is designed to automate the Update, Insert, and Delete SQL operations so that the user does not need to know the otherwise necessary SQL syntax for those statements.
The grid item displays data from the database in a row and column format with each row representing a record in a database table.
By double clicking a field within the grid item, that field becomes editable. You may immediately begin entering data into the field. You can navigate to adjacent fields by holding down the ALT key and pressing any of the Arrow keys.
The Edit pull-down menu works in conjunction with the grid item and provides some very powerful editing tools. The commands are also available on the button bar for easy access.
You will find commands for inserting one or more new rows into the grid item and commands for deleting one or more old rows from the grid item. Typical search, select, and replace operations are present to further enhance your ability to edit the data. You can even change what column to sort the data by for display purposes without having to process the query again.
The user can do any number of updates, inserts, and deletes before pressing the Commit button. Upon pressing the Commit button, all changes would be sent to the database by dbWindow building and submitting all the necessary SQL operations.
You need to download dbWindow 3.0 to try all the powerful features.
