Active Query Builder support area

Number of metadata filter limits ?

Avatar
Andrew Kennard
  • updated
  • Completed

Is there a limit to the number of MetaDataFilterItems that one can add to filter a list of views ?

I'm wanting to filter by a 'list' of specific filenames rather than wildcard filters 'vw%' etc

Is there a low limit or is it effectively unlimited ?

Thanks

Replies 15
Avatar
0
ActiveDBSoft support team

Seems you should ensure you set same SQLSyntax in both AQB instances

Avatar
0
Andrew Kennard

I currently don't set it in code so it should be xsAuto as per your comment in the ActiveX code

// For the ActiveX Edition, use the "SQLSyntax = xsAuto" setting and examine the UsedSQLSyntax property.

So I guess I need to work out what it is after connection and somehow put that in the XML ?

Avatar
0
Andrew Kennard

It seems the SQLSyntax is Auto before AND after Connected is set to true

I don't seem to have a UsedSQLSyntax property ?

Thanks

Avatar
0
ActiveDBSoft support team
UsedSQLSyntax is a read-only property of the IActiveQueryBuilderX

Could you set up some syntax forcely? For example, SQL92 or Universal?

Avatar
0
Andrew Kennard

OK I have now set it to xsMSSQL2008 BEFORE loading the XML or setting connected to True and this seems to have helped