HomeActive Query Builder - Query analysis and modificationProgrammatic modification of SQL queriesHow to add object to the query programmatically

2.1. How to add object to the query programmatically

There are four methods that can help you with this:

  • QueryBuilder.ActiveSubQuery.ActiveUnionSubQuery.AddObject
  • QueryBuilder.ActiveSubQuery.ActiveUnionSubQuery.AddObjectAt
  • QueryBuilder.ActiveSubQuery.ActiveUnionSubQuery.AddObjectWithFK
  • QueryBuilder.ActiveSubQuery.ActiveUnionSubQuery.AddObjectWithFKAt

Methods with the "At" should be used when dragging objects to the Design Pane as they allow to specify position to add object at. Methods with the "WithFK" suffix instruct the component to add joins to the newly added object from other objects that may exist in the active sub-query (according to the foreign keys or by identical field names (CreateLinksByIdenticalFieldNamesCreateLinksFromForeignKeys).

This page was: Helpful | Not Helpful