One more question about text file

[EKC]

I post question earlier and in response got few idea.I prefered approach using comma as delimiter but it doesn't work

Select field1,field2 from Table1 to file Text1.txt delimited
gives me message:
Command contains unrecognized phrase/keyword
What am I doing wrong?
Lyn

 

[csr]

Well, if you lookup the documentation for the SELECT-SQL Command you will find that there is no option like DELIMITED.

That's it. Pretty simple. A syntax error.



Don
dond@csrinc.com

 

[jonscott8]

LOL

EKC, As Dondas said, there is no DELIMITED argument for the SELECT - SQL command.

You are probably confusing it with the COPY TO command, which does have a DELIMITED argument. Refer to the docs for more info. Jon Hawkins
jonscott8@yahoo.com

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed

 

[dgrewe]

You both Right, I overlooked the SELECT command it should be
copy fields FIELD1,FIELD2 to file TEXT1.TXT delimited
David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644