Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to get the table name for a column from an SQL cursor
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
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