Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, November 26, 2024 
 
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 - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Scripting & Customization | New ThreadView:  Search:  
 Author  Thread: Dynamic Data grid with Checkboxes
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
Dynamic Data grid with CheckboxesYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 11 Sep 06 3:09 PM
fiogf49gjkf0d
I have a project that involves programatically getting a list of picklist values (counties actually) from the picklist table, then displaying them in a datagrid and selecting them with checkboxes. I also need to make sure the checkboxes are checked for the selected counties when the screen is in edit mode.

Is there an example in the SLX system someone could point me to? Is this possible, or is there an easier way?

I started to code it and get the right data in the grid, but I can't make the checkbox active (won't let me check them). I need to return the check records from the grid and then update another table with the info. I will be checking the same table to check the boxes on display. I don't currently have the checkbox bound to a real field. I also tried binding it to a field in the picklist table, but it doesn't contain a boolean so wonder if that is the problem..

With grdCounty
.SQL.Text = "SELECT text, picklistID From PICKLIST where PICKLISTID ='" & sPicklistID & "' "

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

'add column for ACCOUNT field
Set col = .Add(0)
col.FieldName = "text"
col.Caption = "County"
col.ReadOnly = True
col.width=150

Set col = .Add(4)
' col.FieldName = "picklistID"
' col.formatType=ftBoolean
col.Caption = "Select"
col.ReadOnly = False
col.DisableEditor= False

End With
'now refresh the grid to see the new columns
.Refresh
End With
[Reply][Quote]
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
All setYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 12 Sep 06 10:09 AM
fiogf49gjkf0d
I found the article about the Checklistbox control on this site. Exactly what I was looking for.
http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=74
[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/26/2024 1:42:55 PM