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