Select * FROM SomeTable INTO ARRAY laARRAY WHERE bla-bla-bla>Is there some way to refer to the columns in the array based on the names of the fields in the table? Or, must I simply know the order of the columns in the table, and use an appropriate index number?
USE (HOME(2) + "\data\products") Select * FROM products INTO ARRAY laARRAY AFIELDS(laFields, "products") * Product Name lnRow = 1 lnCol4ProdName = ASCAN(laFields, "Prod_Name", -1, -1, 1,1+2+4+8) ? laARRAY[lnRow, lnCol4ProdName]Another way
#DEFINE lnCol4ProdNAme 2 ? laARRAY[lnRow, lnCol4ProdName]