Checkbox in Grid, one changes and affects all

[kraus]

i added a checkbox to a grid that contains a cursor of a remote sql datasource. i add the column and checkbox at run time. the column and the checkbox it contains has no control source. i set sparse to false so there is a checkbox on every row. the purpose of the checkbox is to mark each record for deletion. (i know i could enable the delete mark but, that is not what the client wants). when one checkbox is checked, all checkboxes in every row become checked. this can't happen. what am i doing wrong? must there be a field in the local cursor that the checkbox can bind to? your help would be much appreciated.

 

[DSummZZZ]

What is the code in your checkbox?
What is the controlsource?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[kraus]

the code just changes the checkbox value to 1 or zero and deletes record accordingly. ther is no controlsource. does there have to be?

 

[Mike Lewis]

Kraus,

ther is no controlsource.

I think that's your problem. Without a control source, all the checkboxes will have the same value. Or, more precisely, there is only one checkbox -- not one per row.

If you are using a cursor to populate the grid, I suggest you add a logical field to it.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[kraus]

ok - that is what i thought - thank you very much for your help. you da men

 

[Imaginecorp]

One way to do this without adding a field to the source table is to add a logical field to your cursor with the CAST() function: i.e.

SELECT unit_id, CAST(unit_id as Logical) AS lUnit FROM ALIAS() INTO CURSOR temp readwrite

Now populate the Grid using temp. temp.lUnit is the control source for the column with the check box... now you can delete any record that is checked... well you get the idea.

 

[Olaf Doschke]

After you added a logical field and bind the column with the checkbox to it, also don't forget to set the column's sparse to .F.

Bye, Olaf.