copy command with databases

[Geoff Wass [dBVIPS]]

In article <***@news-server>, ***@optonline.net
says...

can i use a database reference in the copy command. The following doewn't
work
use :mydatabase :myfile
copy to :mydatabase:newfile delimited
is there and oodml way to do this
howie

Howie,

You can use the UPDATESET if you are trying to get from one BDE alias to
another.

[Lysander]

Post by Geoff Wass [dBVIPS]
You can use the UPDATESET if you are trying to get from one BDE alias to
another.

You can also use the copyTable() method of the database-object.
But the problem will be to get the "delimited" part working, I guess.

[Bruce Beacham]

can i use a database reference in the copy command.

Not directly. But...

use :mydatabase :myfile
copy to fish3 delimited
set proc to :dUFLP:bdealias.cc
rename fish3.txt ;
to (new bdealias().databasedir("dbasesamples") + "\" + "fish.txt")

is there an oodml way to do this

Have a look at :dUFLP:exportdata.wfm


Bruce Beacham

[hmintzer]

thanks Bruce, your method works fine for what i need

Howie

Post by Bruce Beacham

can i use a database reference in the copy command.

Not directly. But...
use :mydatabase :myfile
copy to fish3 delimited
set proc to :dUFLP:bdealias.cc
rename fish3.txt ;
to (new bdealias().databasedir("dbasesamples") + "\" + "fish.txt")

is there an oodml way to do this

Have a look at :dUFLP:exportdata.wfm
Bruce Beacham

[Roland Wingerter]

Post by Geoff Wass [dBVIPS]
You can use the UPDATESET if you are trying to get from one BDE alias to
another.

---------
Note that Howard wants to create a csv file. This can't be done in OODML -
unless you do it low-level or set up an ODBC DSN using the Microsoft Text
driver.

Roland