Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Huge SDF
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00515172
Message ID:
00515190
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
Nadya,

I am assuming your are using SQL Server as the database and you have th eSQL statement in a stored proc.

Use SQLExec to execute the stored proc and save the resukts to a cursor. Then use :
COPY TO *filename* SDF


>Hi everybody,
>
>I have this problem, which I'm seeking the best solution. I want to extract ~2mln. records from database into SDF file. I can do it in one SQL, but it produces first line with Field names. I don't want them. What's the best way to get rid on field names? Do I need to go SQL into table then copy to file?
Ken Wardwell
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform