Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql to file???
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00662023
Message ID:
00662026
Views:
20
This message has been marked as the solution to the initial question of the thread.
You've to do it in two steps.
SELECT * from temp1 INTO CURSOR crsTemp
COPY TO (sys(2023)+'\tmpCardFile.txt') TYPE SDF
>Hello Everyone!!!
>I have a temp cursor called temp1. I want to write it to a file.
>I have done the following
>
>   SELECT * from temp1 TO FILE (sys(2023)+'\tmpCardFile.txt') PLAIN
>
>
>That gets me the file, but I need this file to go straigt accross for 80 characters.
>The Cursor has up to 3 records in it and each record is 80 characters long. But when I look at the file or send the file to the screen, It is wraped. I need it Straight so that I can send this file to the mainframe.
>Is there a command to help do this or do I have to write some low level writes to handle this?
>
>Thanks in advance
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform