Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get the table name for a column from an SQL cursor
Message
From
29/07/1998 13:45:03
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to get the table name for a column from an SQL cursor
Miscellaneous
Thread ID:
00122384
Message ID:
00122384
Views:
45
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
Map
View

Click here to load this message in the networking platform