General information
Category:
Coding, syntax & commands
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only