Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem for getting infromation from the table.
Message
De
09/01/2002 03:17:32
 
 
À
09/01/2002 00:49:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00602363
Message ID:
00602386
Vues:
18
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform