Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to convert a cursor to a DBF table
Message
From
29/01/2007 06:45:11
 
 
To
28/01/2007 23:26:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01189961
Message ID:
01189994
Views:
9
>with the help of SQL i extract data from various tables and store these rows of data in a CURSOR.
>
>i want to now convert this cursor into a simple DBF file.
>
>How may i do so ?
>
>With sincere thanks in advance.
SELECT fieldA, fieldB FROM MyTable INTO CURSOR MyCursor
* with all the joins you want.
* once you have the cursor:
SELECT MyCursor
COPY TO C:\MyFolder\MyTable
this will copy the cursor to a DBF on disk.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform