HomeActive Query BuilderRetrieving List of Schemas Before RefreshMetadata so can then Use LoadMetadataByMask("",Schema,"")

Retrieving List of Schemas Before RefreshMetadata so can then Use LoadMetadataByMask("",Schema,"")


I hope you Gurus can help!!

I am using QueryBuilder on a SQL database where the Schemas cannot be predetermed.

The QueryBuilder1.MetadataContainer.DefaultSchemaNamesStr returns the Default Schemas AFTER calling QueryBuilder1.RefreshMetadata() and all the QueryBuilder1.MetadataContainer.Items do have their
QueryBuilder1.MetadataContainer.MetadataObject.SchemaStr set.

SO i can post-process the MetadataContainer and remove the Schemas I dont want BUT the load time for QueryBuilder1.RefreshMetadata() is very long so I would prefer to only load the Schemas needed.

I want to be able to display the Schemas present and allow the User to select which they load.

Can this be done? ie how do I predetermine the Schemas?

cheers
Jeff
Jeff Simcock | email
July 30 2009, 01:47 AM
Sorry, we don't have plans to include this feature in the component.
Possibly there is a way to retrieve list of schemes from the database, you should ask your database server's gurus for this.
Sergey Smagin | email
4 days, 3 hours since original post
This topic is closed