Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem for getting infromation from the table.
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement