non operation of COPY TO command 1

[Bryan - Gendev]

I have the following code

Select (myfile)
savetime = TTOC(DATETIME())
savefile= 'my_stats_'+(savetime)+'.csv'
Copy To &savefile Csv
Copy To (savefile) Csv

I get an error on both attempts to COPY TO.

Can any one help a puzzled oldtimer?

GenDev

 

[torturedmind]

Hello,

This is because a file name must contain only valid characters. And based on your code, variable SAVETIME contains forward slashes ("/") and colons (":") which are both NOT allowed in a file name, AFAIK. Try displaying first the content of SAVEFILE first before issuing COPY TO to verify the file name. You may try the ffg. instead:

savefile = "my_stats_ + ;
[indent]DTOS(DATE) + ;[/indent]
[indent]"_" + ;[/indent]
[indent]STRTRAN(TIME(), ":", "") + ;[/indent]
[indent]".csv"[/indent]

kilroy
philippines

"Once a king, always a king. But being a knight is more than enough."

 

[Bryan - Gendev]

Thanks for the heads-up kilroy

Actually, with a cupla edits

savefile = "my_stats_ "+ ;
DTOS(DATE()) + ;
"_" + ;
STRTRAN(TIME(), ":", "") + ;
".csv"

did the trick

GenDev

 

[Olaf Doschke]

That was easy.

Also see TTOC(Datetime(),1), it'll create a string that'll even sort your files correctly, though you can also add a file date column and sort by that.

Bye, Olaf.