As noted in a previous forum posting (http://forums.visokio.com/discussion/529/add-local-link) some Database drivers used in the Omniscope application impose a fixed limit on the number of parametrised values you can pass into a Database query:

The idea presented here is that we develop a workaround to this problem. One possible way we might do this could be to split the query into a number of smaller queries, and then we could append the data together at the end.