Dave

Try DBGETPROP("customer.cust_id", "Field", "Caption")


>>using
>>
>>SELECT Customer
>>SCATTER TO m.laMyArray
>>
>>I obtain an array containing all fields of the customer table.
>>
>>Can I construct an array parallel to this one containing the caption property of each field?
>>
>>I must be able to do this inside a .prg file I cannot have this code working inside a Form or a Form's DataEnvironment.
>
>The only `technique` I can think of is opening the database container as a table ;
>and doing
>
>USE C:\TEMP\CustomerDAtabase.dbc IN 0 ALIAS CustomerDatabase
>
>SELECT objectname , property
>FROM CustomerDatabase
>INTO CURSOR TestWork
>WHERE ParentID = 51
>
>then i could scan through this cursor and parse through the property memo field to obtain the Caption information... but this method sucks :)
>
>anyone have any better suggestions?