11/27/2024 1:23:22 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.
|
|
|
|
editing data in a datagrid SLX V6.2.3
Posted: 08 Dec 06 6:49 AM
|
fiogf49gjkf0d Hi All, I have a 1:many table off of contacts with about 5 fields containing numeric values and text values that I want to display in an editable datagrid. I am building this grid at runtime, I have a sql statement that contains about 4 sub selects that sum a total number of history records by history category and join these 2 tables by userid. I then build the columns in the grid then loop through this recordset from the sql statment and assign row by row the results to the grid recordset which works ok. I can edit the columns that are directly in the custom 1:many table and the grid edited and editing events capture the changes but the data nevers gets posted back to the table? Do I have to loop the grid recordset and update the data in the custom table or should the grid handle this? I currently don't have the grid bindid populated nor do I have the keyfield specified on the grid properties I am going to try this but thought I would put this post out there anyway
Any ideas?
Thanks,
Derek |
|
|
|
Re: editing data in a datagrid SLX V6.2.3
Posted: 09 Dec 06 9:05 AM
|
fiogf49gjkf0d Inline edits work real well with single tables and INNER JOIN multiple tables...... my guess is that you are editing a non databound to the grid record set.....and it doesn't know to post the values......
The grid can give you the row, rowpointer, field edited kind of stuff......and the change is stored in the recordset property.....but there's not rs.UPDATE issued against it.....and with multiple tables and non fields (SUM, COUNT, et al) etc. I don't know if you'd want to do an update against the record set....
What about taking that row, opening up a 1 table record set with the values from that row....and then updating it? |
|
|
|
Re: editing data in a datagrid SLX V6.2.3
Posted: 10 Dec 06 8:18 AM
|
fiogf49gjkf0d FYI...
If "in-Line editing" is used on a "pop-up" form there are usually fewer problems associated with event handling than if the grid is on a "typical MainView tab".
Nature of the beast.
--
rjl |
|
|
|
Re: editing data in a datagrid SLX V6.2.3
Posted: 11 Dec 06 2:26 PM
|
fiogf49gjkf0d Hi RJ, I ended up changing the way I was building this grid:
1) add the columns at AxFormOpen referencing the actual field names in my sql statement
2) build the sql statement with the union to another sql statement
3) set grid.sql = sql statement
4) set the grid bindid property and in the sql properties on the grid as well.
and the end result...........inline editing works like a charm even with a union sql statment.
Thanks!
Regards,
Derek |
|
|
|
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!
|
|
|
|
|
|
|
|