Mobeen,
Try:
?FIELD(1, "Address")
or
SELECT Address
?FIELD(1)
HTH
>I am using the cross-tab query, every time when query is generate it create new field name. I have problem for getting the information from the table because I do not know the field name. Field() function tell me about the name of field but when I use it with the table name it does not show the information and generate the Error.
>
>For example :
>
>Table name = Address && getting cursor through cross-tab procedure.
>Filed name = field(1) && it show the field name “Street”
>When I use this with the table name it generates Error.
>
>---------------------------------------------
>Method 1
>--------
>1- X = address.field(1) && generate error…..
>
>Method 2
>--------
>1- f_name = field(1)
>2- X = address.f_name or address.&f_name && generate error.
>---------------------------------------------
>
>I have problem that I do not know the field name but I want to get the information from the table ….
>
>
>Regards,
>Mobeen.
Daniel