The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Datagrid checkbox column - Erratic behavior
Posted: 26 Oct 08 9:23 AM
|
I've developed datagrids with boolean fields set as checkbox columns. Theoretically, this should allow users to mark datagrid records without having to open a corresponding data form. Problem is, as records (datagrid row columns) are checked, other records also change to checked and/or unchecked.
Appears to simply be a bug. Would be a great feature (if it worked). Anybody have any experience or ideas on this one? |
|
|
| |
|
Re: Datagrid checkbox column - Erratic behavior
Posted: 26 Oct 08 10:14 PM
|
Phil, the grid column is bound to a database field. I'm aware of the .text property of the (form) checkbox control, but not for a datagrid. Is there such a thing?
Basically, I created the datagrid, set the field layouts using the SQL property, then used the Columns property to change the column type to Checkbox.
Thanks,
Ted |
|
|
| |
|
Re: Datagrid checkbox column - Erratic behavior
Posted: 26 Oct 08 10:38 PM
|
Right, the datagrid is on a Manage form.
Whereas the intent is that this be the only editable field on the datagrid (kind of a bypass flag checkbox), yes, if I set other fields as ReadOnly = False I can successfully edit them.
Sometimes checking a datagrid checkbox column seems to work properly, then I'll check another, and one or more other grid rows update to checked. If the datagrid has multiple checkbox columns, often a secondary field checkbox(es) change to checked (so a different field). Pretty weird... |
|
|
|
Re: Datagrid checkbox column - Erratic behavior
Posted: 26 Oct 08 10:52 PM
|
 - you answered my rubbish post - but very sensibly!
That sounds very odd indeed - I would be tempted to try to debug in VS to see whether that gives you any clues. Checkboxes should not tick themselves.
If you can post something here which allows others to reproduce the issue, it would be useful - but I know that would take a fair chunk of time. Without that, it is difficult for me to take this further - maybe someone else will chime in.
Phil |
|
|
|
Re: Datagrid checkbox column - Erratic behavior
Posted: 27 Oct 08 8:26 PM
|
Hi Ted
Yes. There are known (but not documented) bugs in the Slx grid control. Version 7.2 SP2 made it a bit better, but still not perfect. The alternative is to buy a 3rd-party grid control and use that inside Slx.
Cheers
Paul Roussell
Adexio |
|
|
|
Re: Datagrid checkbox column - Erratic behavior
Posted: 31 Oct 08 3:15 PM
|
I've got a few datagrids with 3+ check boxes. NO ISSUES (7.22+, although I was doing this in 6.2.6)
1. Make sure all Row ID fields are in the grid.....maybe not visible but the relevant fields need be present.
2. Inner Join between all tables so SLX doesn't think you are updating multiple records.
3. Databound fields.
4. Take a look at the Editing etc. events. are you doing anything else?
Recall that SLX fires an UPDATE statement for each (and every) cell you edit inline. This is in addition to anything you are firing off.
|
|
|
|