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
Could you set up some syntax forcely? For example, SQL92 or Universal?
It seems the SQLSyntax is Auto before AND after Connected is set to true
I don't seem to have a UsedSQLSyntax property ?
Thanks
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 ?
Seems you should ensure you set same SQLSyntax in both AQB instances
OK the specific problem with this particular query seems to be a difference in one field in online/offline modes that is returneed in the string from LayoutSQL
ONLINE
qvwMoney.Source
OFFLINE
qvwMoney.[Source]
Interestingly a field called qvwMoney.[Group] is [] in both cases
If I add/remove the [] in the debugger then I can load SQL created in one into the other
Setting or getting the LayoutSQL property has no connection with operations perfomed with the Metadata Container...
Thanks, I thought it was me :)
I'm still not quite there in terms of I still cannot set the LayoutSQL from 'online' version to a version that has been loaded from the XML
Still digging
Sorry, my mistake. There's a typo in my message. Please correct "defaut_database" to "default_database".
OK I have now set it to xsMSSQL2008 BEFORE loading the XML or setting connected to True and this seems to have helped