Bad Expression Character???

[forskare]

Would someone plese point out wherre or what is the bad expression character in this line? The forest is awfully thick.

if Isblank(Customer->Lastname),Customer->Lastname.text="Cash Purchase",""
end if

Thanks,

kenn

[JerryBrightbill]

RE: Bad Expression Character???

Ken,

try

if(Isblank(Customer->Lastname),Customer->Lastname.text="Cash Purchase",Customer->Lastname.text=Customer->Lastname)

Jerry

[forskare]

RE: Bad Expression Character???

Jerry,

Isn't that going to override any other name that could be in the field?

kenn

[forskare]

RE: Bad Expression Character???

OK,

I get it. I told you the forrest was THICK!!

Thanks,

kenn

[forskare]

RE: Bad Expression Character???

No go,

Mismatched end of loop or if block

ken

[forskare]

RE: Bad Expression Character???

This expression works in Xbasic, hte check syntax button says the script is OK and no errors were detected.

if (Isblank (Customer->Lastname),Customer->Lastname.text="Cash Purchase",Customer->Lastname)
end if

However, when running the script, the message states

if (Isblank (Customer->Lastname),Customer->Lastname.text="Cash Purchase",Customer->Lastname not found

I understand this to mean that it's not finding the Lastname field, Whether it is or isn't finding the lastname field, why does the Xbasic check syntax button show no errors and when the script is run, the error shows up?

A question out of frustrating, Why can't something that's supposed to be simple, be simple? (I don't spose I'm the first or the last to ask that question) In other words, Why doesn't the field rule's simple expression work when the field is part of the child table?

Thanks,

kenn

[Jeff Moses]

RE: Bad Expression Character???

Ken, Are you using this in a button on a form? Put your field in quotes. When using isblank() yo need quotes on the field. Using to set the value of the Customer field will work in a form but I like to use the following instead.

if isblank("Customer")
t.table_current()
t.change_begin()
t.lastname = "Cash Purchase"
t.change_end(.t.)
end if
'Do other stuff here
end

Jeff

[forskare]

RE: Bad Expression Character???

Jeff,

No, it's not on a button. It's on the fields OnDepart event.

kenn

[forskare]

RE: Bad Expression Character???

Charlie,

Thanks, for respondidng. I tried you expression, changing Customer to Lastname since there is no field called Customer. I get the same results, Xbasic Check Syntex button says the script is OK but when running it, I get the same result, "No Such Field". I'm comming to the conlcusion that for some reason, the field is not recognized when the table is a chilc table. Even when prefacing the field name with the table name, a different error message results.

kenn

[forskare]

RE: Bad Expression Character???

Jeff,

Sorry for missing the name on the last post, Charlie is on the other post which deals with the same issue. The post was meant for you but got the authors mixed up. These started out as separate issues but somehow combined. Thus, I'm going to post a new thread with more clarity, I hope.

kenn

[martinwcole]

RE: Bad Expression Character???

if this.value=""

[martinwcole]

RE: Bad Expression Character???

if this.value=""
this.value="Cash Sale"
end if
also, note this possibility
if this.value="C"
this.text="Cash Sale"
end if

when on a form, I prefer this method, since the mode of the file is irrelevant
otherwise, if you are first viewing a record, and then entering a record, and then changing a record, if you are coding for the file, you have to account for the mode

[Jeff Moses]

RE: Bad Expression Character???

Ken, My typo, I guess I wasn't paying alot of attention! Should have read:

if isblank("Lastname")
t.table_current()
t.change_begin()
t.lastname = "Cash Purchase"
t.change_end(.t.)
end if
'Do other stuff here
end

This works, I'm using it in a number of scripts.
Jeff

[forskare]

RE: Bad Expression Character???

MARTIN!!!!!!!!!!!!!

Thank You Very Much!!! (Huge smile!!) Your script

if this.value=""
this.value="Cash Sale"
end if

WORKED!!!!!!

I almost fell out of the chair!! Now I can add on to it and go from there.

Thanks again,

kenn