VFP 9

Have a grid with a check box on a logical field. How can I update the grid
programatically to clear the check box.

i.e.
check ten items
perform something on just these ten items
and then clear the checkbox

I have tried
thisform.grid1.column1.checkbox.value=0
it does update the underlying cursor if i interupt the program at this line
the records referenced have had the logical field set to false. But as soon
as my grid displays again, the check boxes are checked and the underlying
cursor once again have the logical field set to true. Thanks for any
assistance.

Stefan
Mon May 09 00:40:25 CDT 2005


"Graham" <karaoke@primus.ca> schrieb im Newsbeitrag
news:d0ce5$427e9877$cf706e44$30294@PRIMUS.CA...
> Have a grid with a check box on a logical field. How can I update the grid
> programatically to clear the check box.
>
> i.e.
> check ten items
> perform something on just these ten items
> and then clear the checkbox
>
> I have tried
> thisform.grid1.column1.checkbox.value=0
> it does update the underlying cursor if i interupt the program at this line the
> records referenced have had the logical field set to false. But as soon as my grid
> displays again, the check boxes are checked and the underlying cursor once again
> have the logical field set to true. Thanks for any assistance.

Try updating the grid's underlying recordsource alias itself, e.g.

UPDATE (Thisform.GridX.RecordSource) SET logicalField = .F.



hth
-Stefan


--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Graham
Mon May 09 10:55:55 CDT 2005

Thanks that worked

"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:u5KKnkFVFHA.3620@TK2MSFTNGP09.phx.gbl...
>
> "Graham" <karaoke@primus.ca> schrieb im Newsbeitrag
> news:d0ce5$427e9877$cf706e44$30294@PRIMUS.CA...
>> Have a grid with a check box on a logical field. How can I update the
>> grid programatically to clear the check box.
>>
>> i.e.
>> check ten items
>> perform something on just these ten items
>> and then clear the checkbox
>>
>> I have tried
>> thisform.grid1.column1.checkbox.value=0
>> it does update the underlying cursor if i interupt the program at this
>> line the records referenced have had the logical field set to false. But
>> as soon as my grid displays again, the check boxes are checked and the
>> underlying cursor once again have the logical field set to true. Thanks
>> for any assistance.
>
> Try updating the grid's underlying recordsource alias itself, e.g.
>
> UPDATE (Thisform.GridX.RecordSource) SET logicalField = .F.
>
>
>
> hth
> -Stefan
>
>
> --
> |\_/| ------ ProLib - programmers liberty -----------------
> (.. ) Our MVPs and MCPs make the Fox run....
> - / See us at www.prolib.de or www.AFPages.de
> -----------------------------------------------------------
>