8/23/2025 3:27:45 AM
|
| |
| 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!
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.
|
|
|
|
Datagrid and other Controls
Posted: 13 Feb 08 11:11 AM
|
I have a tab with a datagrid. Below the datagrid there are other controls (picklists, edit boxes, etc). When the user clicks the records in the datagrid, I need to change the data in the controls to correlate to the selected record in the grid. I was going to do everything with scripting, but I wondered if there was some easy way to bind the controls somehow.
I figured I would ask before diving into scripting.
Thanks!
 |
|
|
| |
|
Re: Datagrid and other Controls
Posted: 15 Feb 08 9:04 AM
|
Phil's right, you'll need to script this. To minimize database hits you can include the fields in the datagrid's result set (and set their visible property of the columns property for the select columns to false) then just use the onrowselect event and GetCurrentField function
i.e.
lueMyLookup.LookupID = grdResults.GetCurrentField("A3_MYLOOKUPID") & ""
|
|
|
|
Re: Datagrid and other Controls
Posted: 15 Feb 08 9:48 AM
|
Yeah, I did dive in, and so far I am not drowning.
Yeah, I am using the dg's result set, after I already wrote a function to get the data, then found out about the built in resultset. 
Now I am writing all the scripting to let people change those values, and have it recorded. I am currently trying to manipulate the resultset attached to the dg to do this. All of this is new to me, as I have never worked with dg's before, but its fun. 
|
|
|
|
Re: Datagrid and other Controls
Posted: 15 Feb 08 10:10 AM
|
| writing back to the database is a different story, generally there I don't go through the datagrid's resultset, but just right directly back to the database on the exit of the control (for fields of the type you've described - that way you can refresh the grid too) |
|
|
|
Re: Datagrid and other Controls
Posted: 15 Feb 08 10:14 AM
|
Yeah, I was just noticing that attempts to update the result set are doing nothing. No error, but no change in the resultset as well.
Thanks for the tip. Time to change my tactic. |
|
|
|
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!
|
|
|
|
|
|
|
|