HomeActive Query Builder - IntroductionQuick Start GuidesQuick Start Guide for ActiveX edition

1.8. Quick Start Guide for ActiveX edition

  1. Place the ActiveQueryBuilderX control on the form.

  2. Initialize the ActiveQueryBuilderX.ConnectionString property with the right ADO (OLE DB) or ODBC connection string and to turn the Connected property to True.

    You can find samples of connection strings for many popular database servers at ConnectionStrings.com. Please refer to the "OLE DB providers" sections for the samples of ADO (OLE DB) strings and the "ODBC drivers" sections for ODBC strings.

  3. If you want to let your end-users to combine SQL query text editing with visual query building, add the TextBox or any other text editor control to a form. In case of using the TextBox control you should set its MultiLine property to True.

    Now you should establish connection between the ActiveQueryBuilderX and the TextBox controls.
    Enter the following code to Leave event of TextBox control:

    ActiveQueryBuilderX1.SQL = TextBox1.Text
    

    Enter the following code to OnSQLChanged event of ActiveQueryBuilderX control:

    TextBox.Text := ActiveQueryBuilderX1.FormattedSQL
    
  4. That's all! Now you can run your application.

This page was: Helpful | Not Helpful