Hello,
I am attempting to use VBScript to access search a view for particular items. I have no problems getting the view of the database that I want but I do not know how to search within the view and not just the database. The item I am looking for is not the key as it is the fourth column and creating a view for the column I am seeking is not an option, unfortunately. The database is also not indexed for FTS.
I thought there was a possibility that once a view is obtained “view.SelectionFormula” could be set and then invoked but I don’t seem to have this option through COM. Is there a possibility to use the “SELECT” string from the view, simply add the constraint I have for the item I need, and then use this long “SELECT” string to simply search on the database to account for both view and item?
Any help would be greatly appreciated. Thanks a lot in advance!