copy data from a databse to a external file 1

[some1no]

Anybody could help me in clipper 5 ?

I want to made a data file from a database extraction !
i know this command in dbase mode:

use database
copy to file1 delimited with...


- is this exist in clipper 5.0 ?
- what is the good instruction ?
- can i made a text file, wk4 file or what ?

i run an exe file (prg compiled)

Thanks

 

[Guest_imported]

I don't know in 5.0 but in 5.2 just made and compile
a program like this,

use yourdatabase
set device to printer
set printer to yourfile.txt

**your data extracting code goes above***
**example***
row = 1
do while .not. eof()
@row,1 say name //asuming name is a field in your base
row++
skip
enddo

****
final result is a txt file with a list of names from you
database.

Hope this helps

Jalm

 

[Guest_imported]

I don't know in 5.0 but in 5.2 just write and compile
a program like this,

use yourdatabase
set device to printer
set printer to yourfile.txt

**your data extracting code goes above***
**example***
row = 1
do while .not. eof()
@row,1 say name //asuming name is a field in your base
row++
skip
enddo

****
final result is a txt file with a list of names from you
database.

Hope this helps

Jalm

 

[EzLogic]

Or try the following, maybe easier...

Use YourTable
Set device to print
Set Printer to YourFile.txt

List all to print
*** or ****

List myfield1,myfield2,myfield3,etc... (the fields that you need)


Good luck! Ali Koumaiha -)

 

[some1no]

Thanks for all of you, who have taken the time to answer me !!

Bye