HomeActive Query BuilderCan I prevent AQB from automatically linking new tables?

Can I prevent AQB from automatically linking new tables?


Hi,

Can you please tell me how I can configure AQB so that it doesn't automatically link new tables as I drag them in to the query?

Thanks in advance,
Ivan.
Ivan Robinson
June 30 2008, 08:49 AM
Dear Ivan,

One of the possible ways is to iterate through the metadata container objects and remove all foreign keys from it:

ActiveQueryBuilderX1.Connect
ActiveQueryBuilderX1.RefreshMetadata

For i = 0 To ActiveQueryBuilderX1.MetadataContainer.Count - 1
ActiveQueryBuilderX1.MetadataContainer.Items(i).Relations.Clear
Next i

Sincerely
Sergey Smagin
Sergey Smagin | email
2 days, 16 hours since original post
This topic is closed