Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get the table name for a column from an SQL cursor
Message
De
29/07/1998 13:45:03
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to get the table name for a column from an SQL cursor
Divers
Thread ID:
00122384
Message ID:
00122384
Vues:
46
Can anyone tell me if there is a way of finding out the table name for a particular column once you've created an SQL cursor?

For example if I have the statement:

SELECT Cfpeople.pe_peopleid, Cfaddres.ad_street, ;
Cfdistri.di_diname INTO cursor mycursor

then browse, I'd like to do some field manipulation. FIELD() just tells me the field name, not the original table associated with that field. The SQL must retain this info someplace in order to create a cursor from multiple tables, but I can't figure out how to get to it.

Thanks for any help on this.

Sylvia
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform