Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL and spaces
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00100363
Message ID:
00101135
Views:
25
Curtis,
SDF does mean fixed length but the spaces occur from the SQL TO FILE
statement. The COPY TO command omits the spaces. I asked our Oracle
people and the same thing occurs with them. The difference being is that
they can issue a command before he SQL statement to rid themselves of the spaces. Is there anything is VFP that can do the same is the question.

When handing off these files to other sources, the spaces can cause havoc for instance with a SAS programmer.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform