The Query builder control, similar to the one used in the graphic query designer for the Datawindow, offers native support for Oracle, SQL Server, SQL Anywhere and Syabse ASE. Generic ODBC connections are also supported. Other DBMS's can be added on a per request basis.
Open Event of your Window:
//Set parent window uo_1.of_SetParentWindow( THIS)
Call the following whenever you're ready to connect your querybuilder control to your database:
//Tell querybuilder you're connecting to SQL Server uo_1.of_SetDBMS(uo_1.SQLServer) uo_1.of_SetTransactionObject(SQLCA) //Display the table popup so users can start adding tables to their query uo_1.of_AddTable()