dbWindow 3.0 removes all the stumbling blocks to using a database with MicroStation
The SQL Select Statement Builder dialog provides a user friendly interface to help automate constructing the syntax for Select statements. Select statements can now be built by simply pointing and clicking with a mouse.
dbWindow users no longer need to know SQL at all :
This dialog allows users to build Select statements without knowing the syntax.
The SQL statement management system aids in describing and organizng statements.
The grid item automates Insert, Update, and Delete statements.
On the first tab the user specifies what columns from what tables are to be included in the SQL Select statement. This tab also provides a way to set up the function part of a Select statement with max, min, count, avg, and sum.
The second tab is dedicated to building the Where clause. This clause is used to help limit the database search or in other words narrow the query by building one or more conditions.
The third tab is for the Group By, Having, and Order By clauses which are not as commonly used.
