ASE offers yet another first in scripting: A simple tool for the generation of complex Database code. Connect to any ODBC data source (Access, SQL, etc.) and select any table or view with which you want to work. Then select the fields you wish to query, update or add. More customization is offered in the "settings" page, but that is all there is to it!

Need more than a simple select, insert or update statement? Right click on databases in the DB Wizard to call the Advanced Query Builder (AQB) where you can create more complex statements like joins graphically be selecting tables, checking fields and dragging fields between tables to specify links.

"Work a lot with databases? Find yourself using your database's native SQL Query tool? Maybe you've repurposed Microsoft Access just for the query builder. ASE answers that with the inclusion of these tools. Quickly and graphically connect to your target database and easily generate/insert all the code required to make the connections and execute desired queries."
--Dx21.com

So many features you never knew you needed

Be sure to also check out...