slxdeveloper.com Community Forums

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!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: Checkbox Control in 6.2

Nicholas Fine
Posts: 1

Checkbox Control in 6.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jul 07 12:43 PM

I'm having some trouble with a checkbox control on a dynamically created datagrid. The checkbox shows up on every line, but does not allow the user to change its setting. Here is the code I have so far:

With dgCrateDetails
.SQL.Text = "SELECT CRATEITEM, CRATENUMBER, LINEITEMNUMBER, ISCHECKEDOUT FROM EMSTORECRATE WHERE emstorecrate.emstoreid = '" & strCurrentStoreItem & "'"

With .Columns
'remove any existing columns
If (.Count > 0) Then
For i = 0 To .Count - 1
.Item(0).Delete
Next
End If

Set col = .Add(4)
col.FieldName = "ischeckedout"
col.Caption = "Choose"
col.Width = 50
col.ValueChecked = "T"
col.ValueUnchecked = "F"
col.DisableEditor = False
col.ReadOnly = False

Set col = .Add(0)
col.FieldName = "lineitemnumber"
col.Caption = "Item #"
col.Width = 50

Set col = .Add(0)
col.FieldName = "cratenumber"
col.Caption = "Crate #"
col.Width = 50

Set col = .Add(0)
col.FieldName = "crateitem"
col.Caption = "Item"
col.Width = 600

End With

.Refresh
End With

I'm using SLX Architect 6.2.6.1007. Thanks in advance for any help!

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Checkbox Control in 6.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jul 07 8:24 AM

I think this might have something to do with a possible disconnect with the datagrid columns and the datagrid's underlying recordset. This would have to do with the way you build the datagrid in the code. Another possibility is that you have nested "With" sections - and it might be confusing the code - Take out the "With .Columns" and put the ".Columns" in every spot it belongs.

Other than that, you may want to call a business partner or look at other plugins to see some examples on building datagrids.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Checkbox Control in 6.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jul 07 10:22 AM

The nested With blocks are fine as long as they are off the same object - which they are for your code.

Does the grid itself have the property for ReadOnly set to true. Does it have it's RowSelect set to true? You'll want to make sure those are false.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/7/2025 5:55:43 PM