Command Append

[LucaFcs]

I have a text file with no delimiter but composed as follows:
173 FLOWER FIL. MERL. 400GRX1,00 CT6E2714 8410063011448
25002 Viennetta VANILLA 6X320 1.00 CT3231BC020 8000920200025

I CREATED QUATO COMMAND:
CREATE CURSOR TIME (Codart C (10), desart C (25), PRICE N (9,2), UM C (2), LOT C (20), BARCODE C (16), EXTRA C (15), N CPROWNUM (3))
APPEND FROM ("c: \ VENDUTO020.TXT") TYPE DELIMITED

BUT WRONG DATA SHOWS
HOW CAN I SAY TO IMPORT IN FIELD1 FROM 0 TO 10, FIELD2 10 TO 25, field3 FROM 35 TO 9 ECC ECC.
THANK YOU

 

[Olaf Doschke]

TYPE SDF should do:

APPEND FROM file TYPE SDF

Bye, Olaf.

 

[GriffMG]

Is the TYPE part of that necessary?

APPEND FROM (m.FILENAME) SDF

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are not good for you. ​

 

[Mike Lewis]

Is the TYPE part of that necessary?

No. The keyword is optional.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

Correct. I like verbose, in the byte code it will be the same anyway.

Imagine

APPEND FROM MYFILE SDF

Coming back to this code months later or as a new developer, you might be tempted to change it to

APPEND FROM MYFILE.SDF

...which of course won't work anymore.

But that's just me.

Anyway, that doesn't apply to your version of using (m.Filename).

Bye, Olaf.

 

[LucaFcs]

thanks