Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get table names from select sql
Message
From
06/05/2004 10:44:23
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00901535
Message ID:
00901567
Views:
12
How about

SELECT Mytable
cFields = ""
FOR i= 1 to FCOUNT()
cFields = cFields+FIELD(i)+[,]
ENDFOR


Then delete the last comma and you have a list of fields.

>Hi
>I have a select sql instruction, and I want to extract a string with the table names.
>¿There is any object, function, procedure with this functionality?
>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform