Im looking for advice on working with Arrays built from the sc_lookup() macro.
It returns the database query as a multidimensional array WITHOUT column names. Is there any way to get the column names from this query?
sc_lookup(MyArray,‘select columnA,columnB from MyTable’);
would return MyArray as the data in columnA and MyArray as the data in columnB first row.
MyArray for data in columnA 2nd row and MyArray as data in columnB 2nd row.
and so on.
What’s the best way to get this indexed array to an associate array where I have the column names?
Is there a way to get the column names with built in Scriptcase macros?
Thanks for any pointers!