>Franze,
>
>Could you give an example when the actual error occurs or the padding behavior is not acceptable? For instance, there are no errors in this scenario:
>
>
>sele junk
>APPEND FROM C:\TEMP\JUNK.txt SDF FIELDS INT1, FNAME, LNAME
>
>
Yuri,
Well, I would rather the result were predictable - as I said, the pad amount varies with different numbers of fields, etc... Moreover, I'm bulk loading into SQL SERVER using format files and I don't know how big (in advance) the integer column will be written from VFP, judging from this example.
Here's another interesting example:
CREATE CURSOR Mewp (int1 I, int2 I, char1 c(10), char2 c(10))
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4)
INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6)
COPY TO c:\temp\temp1.txt FIELDS char1, char2, int1, int2 sdf
The integers are LEFT justified, 10 characters long
- Franz