Script works with memo field fails with character field

[werder101010]

I'm using the content of two fields to name / save a pdf file. One of the fields was a memo field (by accident). It worked. When I changed the memo field to a character field the same script produced an error: .pdf' cannot be created. I don't understand why? I tried "database compact" and restarted alpha but this didn't help.

I also noticed that there is a lot of empty space between the two fields. Like this: field1. . . . . field2.pdf Is there a way to prevent this? I did notice that field1 and the empty characters are exactly the width as defined in the table.

Here is the script I use:

tbl = table.current()
number = alltrim(tbl.adm_nr)
client = alltrim(tbl.client)
base_path = "C:\clients\\"
dir_name = number+" "+client
dir_create_recurse(base_path+dir_name)

record_number = current_record_number()
query.filter = "recno() = " + record_number
query.order = ""

report.saveas("report 6", "PDF", query.filter, "",base_path+dir_name+"\\"+"letter "+adm_beroep->BR_ORGAAN+adm_memo->M_VV_OW_6+".pdf")

[Stan Mathews]

Re: Script works with memo field fails with character field

Is there a way to prevent this?

Please.

Please.

Please study the documentation for alltrim().

The .dbf format stores data in fixed width fields.

If you reference a character field's contents, you retrieve the perceived contents and the trailing spaces.

dir_name = number+" "+client

I believe you will be better served in the future if you select a character other than a space for the purpose of readability(?). Spaces will lead you to nothing but grief in the long run.

dir_name = number+"-"+client

dir_name = number+"_"+client

Note the previous sugggestions

number = alltrim(tbl.adm_nr)
client = alltrim(tbl.client)



These are more reliable.

[werder101010]

Re: Script works with memo field fails with character field

Thanks Stan, I now understand what the alltrim function is for and how I can refer to it later in the script.

Spaces will lead you to nothing but grief in the long run.

Is this also the case when I use the space function?

tbl = table.current()

subject = alltrim(adm_memo->M_VV_OW_6)
orgaan = alltrim(adm_beroep->BR_ORGAAN)
number = alltrim(tbl.adm_nr)
client = alltrim(tbl.client)

base_path = "C:\clients\\"
dir_name = number+" "+client
dir_create_recurse(base_path+dir_name)

record_number = current_record_number()
query.filter = "recno() = " + record_number
query.order = ""

report.saveas("report 6", "PDF", query.filter, "",base_path+dir_name+"\\"+"letter"+ SPACE(3)+orgaan+ SPACE(3) +subject+".pdf")

[werder101010]

Re: Script works with memo field fails with character field

Can this also be used without problems in the long run??

report.saveas("report 6", "PDF", query.filter, "",base_path+dir_name+"\\"+"letter"+ SPACE(1)+orgaan+ SPACE(1)+"-" +SPACE(1)+subject+".pdf")

[Stan Mathews]

Re: Script works with memo field fails with character field

The most common practice, which I find unnecessary and potentially harmful, is the use of a space in an Alpha table name.

I probably carry things too far when I avoid the use of spaces in paths

number = "12345"
client = "ABC Company"

dir_name = number+" "+client
? dir_name
= "12345 ABC Company"

dir_name = number+"[COLOR="Red"]_[/COLOR]"+client
? dir_name
= "12345[COLOR="red"]_[/COLOR]ABC Company"

And since I'm already obsessive about the space I generally avoid spaces in output file names. Go with whatever works for you.