netsys
Posts: 39
|
| Posted: 08/02/2010, 2:35 PM |
|
I'm trying to do something very similar to a previous poster - post was here: http://forums.yessoftware.com/posts.php?post_id=98821&s_keyword=update+row
I am using an editable grid to update a table, and only want to update the rows where a checkbox (regstatus) changes value. I seem to be having trouble accessing the value of this checkbox.
Here is my code that I have put into the BeforeExecuteUpdate area of the editable grid:
if registrations_Students.regstatus.value = ccdlookup(regstatus, registrations, RegID=registrations_Students.Hidden1.value) then
registrations_Students.DataSource.CmdExecution = false
end if
I get an error that variable regstatus is undefined, so it seems I'm not getting that value. I've tried going through the various suggestions from this page: http://forums.codecharge.com/posts.php?post_id=60507 but couldn't seem to get the value.
|
 |
 |
lboeldt
Posts: 53
|
| Posted: 08/03/2010, 8:15 PM |
|
Shoud the regstatus value in the ccdlookup command be: registrations_students.regstatus.value rather than just regstatus?
|
|
|
|
Waspman
Posts: 948
|
| Posted: 08/06/2010, 1:30 AM |
|
I do this by using a hidden holder. Populate it with the original value when page loads.
Compare it with the field that populated it in the before update event. Then proceed as required. 
_________________
http://www.waspmedia.co.uk |
|
|
|
netsys
Posts: 39
|
| Posted: 08/06/2010, 6:06 AM |
|
Thanks - the hidden holder idea seems like it will work. Will give it a try.
|
|
|
|
|
