I think I have come across a bug in VFP9 SP1.
Using the COPY TO command when a field is one character long and it's empty the output file will have a space in that position but if the field is two or more characters long the position will not have the space.
CREATE CURSOR test1 (f3 c(3),f2 c(2),f1 c(1),n1 n(1,0),n2 n(3,1))
APPEND BLANK
COPY TO test1.txt DELIMITED WITH "" WITH CHARACTER "|"
Output File:
|| |0|0.0
Note that the field f1 in the output file shows a space when it should be empty like f2 and f3.
Has anyone else ever ran into this before?
Dennis