Submitted by gregory on 2009/08/10 09:33
Hello. It is possible to execute an SQL SELECT statement in various places in InfoQube, for example, as part of the Field Options.
 
But can an SQL SELECT statement be executed within a user defined function written in VBScript in such a way that the results are stored as elements in an array? If so, how?
 
What I would like to be able to do is to extract a list of current values for a field, so that I can cycle through those values and/or validate another field against that list of values. One application I have for this is classifying items by keyword.
 
I know that I can achieve this using Microsoft ADO, but I don't have all the technical information I need to make this work - connection strings, etc. In any case it might be wise to insulate users against that level of detail. This could be done by adding a simple function to System Code which returned an array of the current values of a named field.
 
Thanks for any suggestions or other light you can shed on this!
 
Mark Gregory

Comments

AFAIK, VBScript does allow creation of an ADO object which should allow you to do what you want. But this is not officially supported (same for any other DB operation done outside IQ).