Being thick - set checkbox property

[nickty]

Hi, I'm being a bit thick, but can't work out how to set a checkbox either checked or unchecked programatically.

I have 12 non-database items on my form. I have a cursor which is returning some data from d/b, and want to set 1(or more) checkboxes to checked depending on data returned.

I've looked in help and it says use set_item_property, but which property?

sorry if this is a silly question! , thanks.

 

[lewisp]

If the checked value is Y and the unchecked is N, you set it to checked using an assignment:

[tt]:block.check_box_item := 'Y';[/tt]

 

[nickty]

thanks, but they are not y or n.
the data returned will be a number from 1 to 12,
so if the cursor returns, for example 4 and 5
I want to set checkbox 4 to 4
and checkbox 5 to 5, if you see what I mean!

 

[sem]

Checkbox can be only in 2 states: checked and unchecked. How can you assign 5 to it? If you need only to switch it on, you may create a set of checkboxes named e.g. CHECKx where x is the order number of your checkbox with checked/unchecked values provided by lewip, and use COPY command to change the value.

for c in cursor loop
copy('Y', 'block.CHECK'||c.value);
end loop;

Regards, Dima

 

[MissJules]

Dima, I agree a check box can only be checked or unchecked
but
When you specify you Value when checked and Value when Unchecked you specify what the value must be...

so nickty you would then be able to use the code (similar to what Dima said)

for c in cursor loop
copy(c.value, 'block.CHECK'||c.value);
end loop;

Cheers
Julie

 

[nickty]

thanks all

...MissJules, you are correct, i was trying to specify the 'value when checked' to either 4, 5 etc.

However, I have changed the form so checkboxes are either Y or N based on data returned from d/b.


thanks all for your help, it is now working great!