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]