Query Builder

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.

PB Ultimate Suite Query Builder


Implementation

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()