checkbox IF....THEN syntax

[Marc King - A5solutions]

Hi All,

I have a form with checkboxes tied to session variables "wk1" "wk2" "wk3" wk4".

I want to run a script from a button on the form that will copy current record in tables (T1, T2, T3, T4)to a master table based on which check boxes are checked.

I'm trying to use a nested IF...Then...Else

If var-"wk1 = .T. then
'copy to master table code
else

If var-"wk1 = .T. then
'copy to master table code
else

If var-"wk1 = .T. then
'copy to master table code
else

If var-"wk1 = .T. then
'copy to master table code
else


Is this correct Syntax?

I keep getting a "wk1" is incorrect data type error when I run the script.


Thanks
Marc

[Marc King - A5solutions]

RE: checkbox IF....THEN syntax

oops should be


If var-"wk1 = .T. then
'copy to master table code
else

If var-"wk2 = .T. then
'copy to master table code
else

If var-"wk3 = .T. then
'copy to master table code
else

If var-"wk4 = .T. then
'copy to master table code
else

Thanks

[martinwcole]

RE: checkbox IF....THEN syntax

be sure the session variables are type-"logical

[Tom Cone Jr]

RE: checkbox IF....THEN syntax

Marc,

If you're working with checkboxes (and not radio buttons), then one or more could be checked, right?

So, don't nest the IF ... END IF sequences, process them one at a time, like this:

'script begins
if var->WK1 = .t. then
  'do your processing
end if

if var->WK2 = .t. then
  'do your processing
end if

if var->WK3 = .t. then
  'do your processing
end if

'and so on and so forth
'script ends

This kind of script will probably benefit from
putting the statement

xbasic_wait_for_idle()

after each copy sequence in order to pause the script
until the copying is finished.

-- tom

[AaronBBrown]

RE: checkbox IF....THEN syntax

Proper IF/ELSE syntax would be, depending on your situation:

IF condition
ELSE IF condition2
ELSE
END IF

...or....

IF condition
ELSE
END IF

The END IF is not optional. The THEN is optional (I never use it as it doesn't make code any more readable).

[CALocklin]

RE: checkbox IF....THEN syntax

Marc,

I create a layout variable called Logic_test on my Test form then used the drag-and-drop to put that variable on the form itself and changed it to a checkbox format.

The following script ran perfectly:

IF var-"logic_test
ui_msg_box( "TRUE", "" )
ELSE
ui_msg_box( "FALSE", "" )
END IF

It also works with "IF var-"logic_test = .T." but the "= .T." isn't necessary.

If yours isn't working, I'd have to go along with Martin - make sure your variables are type "logical". You also didn't say *where* you were defining the session variables. Maybe this is the problem. Mine were defined right on the form.

[Marc King - A5solutions]

RE: checkbox IF....THEN syntax

Thanks , I think that is the problem. I defined the variables from the toolbar.

Marc

[CALocklin]

RE: checkbox IF....THEN syntax

Since a "session" is related to a form, I think any variables created from the toolbar would have to be global in order to be seen on other forms.