HomeActive Query BuilderAPI to add/remove view/ table to the DiagramPane

API to add/remove view/ table to the DiagramPane


Hi,
I am evaluating the tool -I am using the free version.
I want to use my custom metadata tree and to have ability to add view/table to the DiagramPane - I tried to use QueryBuilder control, I set the MetadataTree as visible false and I try to find some API that could help me to add /remove objects to the DiagramPane.
Since there is no documentation can you please advice how can I do it?

Thanks
Kety
kety | email
January 13 2011, 03:01 AM
Dear Kety,

There are several ways to remove unwanted objects from the tree:
- using metadata filters
- manual removal of objects from the metadata container
- saving metadata to the XML file and modifying it using metadata editor.
All of these ways are briefly described in the knowledge base at http://www.activedbsoft.com/helpdesk/index.php?pg=kb.chapter&id=3
Sergey Smagin | email
3 hours, 24 mins since original post
Hi Sergey,

Can you please explain or give me example ,how can I add table to the Diagram Pane from the code (what is the API)
I have ActiveDatabaseSoftware.ActiveQueryBuilder.QueryBuilder control.
From the code I try to search for method "AddObjectToDiagramPane(...) ,GetDiagramPane....
But the only events that I have are: DiagramObjectAdded, DiagramObjectAdding.This mean that the only options to add new object to diagram pane is by drag and drop from the metadata tree or by AddForm.
We want to use QueryBuilder control as part of our UI ,but the metadata tree won't be visible and we will have custom tree that will organize the metadta tables in folders.
How can I do this implementation?

Thanks
Kety
kety | email
1 week, 3 days since original post
Dear Kety,

The QueryBuilder.ActiveSubQuery.ActiveUnionSubquery has the following methods:
- AddObject: adds object to the query
- AddObjectAt: adds object to the query in specific position (useful for drag'n'drop)
- AddObjectWithFK: adds object to the query and links it automatically with other objects according to the foreign key information
- AddObjectWithFKAt: combination of the previous two methods.

You may find example of working with these methods in the Drag'n'Drop demo project that included in the installation package.
Sergey Smagin | email
1 week, 3 days since original post
This topic is closed