mismatched fields

[Edward F. Schulz]

Hi Phorum,

On the onarrive event of a field named calc_multi, I have the following snippet:
if(rnd_trp="Y",rnd_trip,1)

rnd_trp is a character field
rnd_trip is a numeric field = 2
calc_multi is a numeric field

Am I blind, this gives the error of mismatched fields.

All help will be appreciated,
efs

[Ohlen Cartmell]

RE: mismatched fields

Ed,
How have you defined calc_multi in field rules. If as a calculated field, the calculation must be supplied in field rules. If as a user entered field, then you must assign the value of the if statement to the field. Would be something like

this.value=if(rnd_trp="Y",rnd_trip,1)

[Ohlen Cartmell]

RE: mismatched fields

Additional thought(s).

You may be mixing form values with table values. You may need something like:


this.value=if(rnd_trp.value="Y",rnd_trip.value,1)

[Edward F. Schulz]

RE: mismatched fields

Hi Ohlen,
Thank you for replying. I didn't use the field rules, I put the snippet
on the onarrive event of calc_multi. I had hoped that this will
eventually be a select/case function.

[Tom Cone Jr]

RE: mismatched fields

Ed, Ohlen's question is a good one. Is 'Calc_Multi' a calculated display field on your form, or is it simply a normal text field object showing the value of a variable?

Xbasic contains commands that permit you to talk to objects on the form. It also has commands that permit you to talk to the table beneath the form. We can't tell from your snippet what you're doing, because you haven't told us about the table fields, form fields, and variables that are in play here.

If Calc_Multi is a calc field defined in the form you cannot assign a value to it directly, though you can refresh the field object on the form ( often not necessary).

If Calc_multi is a simple variable, displayed in a field object also called 'Calc_multi' you can write to the variable, and then refresh the field object on the form, like this:

var->Calc_multi = "Boo" 'assign value to variable
:formname:Calc_multi.refresh() 'refresh object displaying variable on form

Or,

you can write straight to the field object on the form, like this:

:formname:Calc_multi.value = "Boo"

Notice that the syntax is different when writing to form objects, than when writing to variables directly.

If the field object on the form has been renamed to something else, like 'object_name', then these examples become:

var->Calc_multi = "Boo" 'assign value to variable
:formname:Object_name.refresh() 'refresh form object

and

:formname:Object_name.value = "Boo"

respectively.

-- tom

[Edward F. Schulz]

RE: mismatched fields

Hi Tom and Ohlen,

Calc_multi is a simple "user entered" field in the table. The snippet
is suppsed to set calc_multi to rnd_trp (which is 2 for this record)
if rnd_trp is a "Y", if not to a 1.

[Tom Cone Jr]

RE: mismatched fields

Ed, is it possible there's a fieldname typo in your script, just as there is in your last post? Otherwise, maybe it's time for you to post a working sample so we can see it?

-- tom

[Edward F. Schulz]

RE: mismatched fields

Hi Tom,

OOPS, I left an "O" out of supposed. Usually I don't get typos on the fields because I drag them into the expression, my booboos are the garden variety of omitting parenz and hitting the period instead of the comma. Last night I changed calc_multi to a calculated field and inserted the following expression:
if(rnd_trip="Y",rnd_trip,1) and it seems to be working. However this is merely a preliminary test to achieve the desired results. My hope is to replace the expression with a select/case since there are other values that can effect calc_multi.

Question .... can a select/case of 6 or 7 cases be placed in a field rule expression? Since the differnt cases are usually different values, I am placing the largest value as the first case etc on to the smallest as the last. This should produce the largest proper value and omit the lower ones since select will close when it reaches a true value. It appears that I was not aware of the fact that I could not set the vaue of a user entered table level numeric field with an expression on the onarrive event. I am formulating the select/case now in MSWord for a copy and paste.

I can not believe the patience people like yourself and others have with part time quasi developers like me. This forum is unbelievable.

Thanks a million,
efs aka ED

[Stan Mathews]

RE: mismatched fields

You can't use select .. case in a calculated field rule, you can use the case() function, limited to 16 pairs of expressions and results.

[Tom Cone Jr]

RE: mismatched fields

Ed, I was more concerned with the 'i' left out of rnd_trp.

-- tom

[Edward F. Schulz]

RE: mismatched fields

Hi Stan,

Thank you, that saves me a lot of unnecessary work.
efs