Home → Active Query Builder

Active Query Builder

• 1. Metadata handling and filtration
  • 1.1. Metadata pre-filtration
  • 1.2. Loading metadata from several databases
  • 1.3. Working with Metadata Container
  • 1.4. Loading metadata from XML file
• 2. Programmatic modification of SQL queries
  • 2.1. How to check all fields on adding an object to the query
  • 2.2. How to add a relation programmatically
  • 2.3. How to define aliases programmatically
  • 2.4. How to insert DISTINCT keyword into a query
  • 2.5. How to add TOP clause to MS SQL Server query
  • 2.6. How to add LIMIT clause to MySQL query
  • 2.7. How to add FETCH FIRST to DB2 query
  • 2.8. How to add/check ROWNUM condition in Oracle query
• 3. Localizing Active Query Builder
  • 3.1. Available languages
  • 3.2. Selecting language in run-time
  • 3.3. Localizing Active Query Builder .NET and Java Edition
  • 3.4. Localizing Active Query Builder VCL and ActiveX Edition
• How-To
  • 1. How to work with parameters
  • 2. How to validate a query (syntax analysis only)
  • 3. How to override the version binding in .NET
  • 4. How to use DevExpress controls in .NET Edition?
  • 5. How to work with the .NET Edition using DevArt dotConnect (Core Lab ADO.Net providers)?
  • 6. How to modify context menus
  • 7. How to hide the "Main" tab?
  • 8. How to detect database server (SQL syntax)?
  • 9. How to drag an object from the metadata tree outside the component?
  • 10. How add an object to the query building area by dragging from external list?
  • 11. How to distribute ActiveX control automatically through the Internet Explorer?
  • 12. How to sign Java applet?
• Troubleshooting
  • 1. Using Active Query Builder VCL Edition with DevExpress Skins
  • 2. Unit acQB***MetaProvider was compiled with a different version of ***
  • 3. Using Java applet in ColdFusion
  • 4. My Java applet doesn't work in a browser!

Active Query Builder: Printer Friendly Version