Putfile() error

[rdd1963]

I followed the example in the documentation for Putfile() function, but am getting an error if I add expc1 and expc3. without these it appears to work. Any ideas?

example:
cProgramSaveAs = putfile("Save the program","default.prg","prg")

My code:
copy to putfile("Save file As:","payrollexport.csv","csv") fields id, classify, category, amount, blank1, blank2, blank3 delimited

Helps if I give the error:

**** Lianja error ****
to putfile("Save file As:","payrollexport.csv","csv") fields id, classify, category, amount, blank1, blank2, blank3 delimited

^
Syntax error in command
Called from procedure - pto_menu_export_click at line 108

I have since tried to save the file path to a variable and that that point the dialog box comes up, but still gives the following error:

**** Lianja error ****
to test2 fields id, classify, category, amount, blank1, blank2, blank3 delimited

^
Field variable was expected
Called from procedure - pto_menu_export_click at line 108

If I use putfile() by itself, it works properly.

[josipradnik]

Hi,

Saving path is way to go.
COPY TO is problematic. You can simulate this error in Southwind database:

open database southwind
use customers
copy to aaa fields customerid,companyname
*  OK
copy to aaa fields customer id, companyname
* error if typo in table column name "customerid" vs. "customer id"

**** Lianja error ****
copy to aaa fields customer id, companyname
^
Field variable was expected

Check your table column names.

Isn't "Field variable" misleading in the error?
Imagine this:

id="customerid"
copy to aaa fields &id, companyname
* OK

Josip

[yvonne.milne]

Hi RD,

Enclose the putfile() in brackets so it is evaluated:

copy to (putfile("Save file As:","payrollexport.csv","csv")) fields id, classify, category, amount, blank1, blank2, blank3 delimited

Regards,

Yvonne

[rdd1963]

Thanks Yvonne,

Here a a couple things I noticed. The pre-populated filename of payrollexport.csv did not appear. I had to type it in manually and noticed that if I don't put the file extension on it, it will not include it even though .cvs is noted as he save as type.

Also if I hit cancel from the save as dialog box, I get the following error:

**** Lianja error ****
to (putfile("Save CBiz Export File","payrollexport.csv","csv")) fields id, classify, category, amount, blank1, blank2, blank3 delimited

^
Filename was expected
Called from procedure - pto_menu_export_click at line 108

[rdd1963]

Thanks Yvonne,

Here a a couple things I noticed. The pre-populated filename of payrollexport.csv did not appear. I had to type it in manually and noticed that if I don't put the file extension on it, it will not include it even though .cvs is noted as he save as type.

Also if I hit cancel from the save as dialog box, I get the following error:

**** Lianja error ****
to (putfile("Save CBiz Export File","payrollexport.csv","csv")) fields id, classify, category, amount, blank1, blank2, blank3 delimited

^
Filename was expected
Called from procedure - pto_menu_export_click at line 108

This was after I put the statement in brackets.

[yvonne.milne]

Hi RD,

Can you submit a ticket for the pre-populated filename not appearing and file extension required. https://www.lianja.com/support/newticket

If you cancel, then putfile() will return an empty string, so depending on whether you want to force the copy and a filename or cancel the operation completely you need to handle that.

Regards,

Yvonne