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.