Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save results to a table
Message
From
05/08/2008 13:07:20
 
 
To
05/08/2008 13:04:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01336600
Message ID:
01336604
Views:
9
>I have a fairly complicated cursor (within select records) calling up date reports is there a command to add somewhere toward the end to save these cursor results to or into a table??

Just run a query against it to a table:

SELECT * FROM YourCursor INTO TABLE NewTable

If you need to add them to an existing table, use APPEND FROM:

SELECT YourTable
APPEND FROM DBF("YourCursor")

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform