Waspman
Posts: 948
|
| Posted: 02/28/2006, 5:27 AM |
|
I'm having problems trying to update a date field when an editable grid is updated.
Using the "Before Build Update" I'm assigning the current date to the field i.e.
Users.LastUpdate.Value = Date()
Simple stuff, but it doesn't work.
Any ideas anyone?
Many thank...Tony
_________________
http://www.waspmedia.co.uk |
 |
 |
kevind
Posts: 251
|
| Posted: 03/03/2006, 8:55 AM |
|
I'd have to double check - but I think you can use the 'custom insert' feature with Type=Table for the grid and put Date() as an expression for the grid control LastUpdate. The rest of the fields get their values from their controls - try it out and let me know.
Assuming 'Users' is the editable grid you created.
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
Vasiliy
Posts: 378
|
| Posted: 03/04/2006, 8:33 AM |
|
Had similar problem with editable grid, but for control with .Visible = False (ASP VB).
Can not init row fields on "Row Validate" or in "Before Build Update" if .Visible = False.
IMO, even if control is not visible in editable grid, fields init in "Row Validate" or in "Before Build Update" should work same as in CCS update form ... at least for consistency. 
_________________
Vasiliy |
|
|
|
Waspman
Posts: 948
|
| Posted: 03/06/2006, 1:33 AM |
|
The only way I can get it work is to run an update script in the AfterUpdateExecute function.
Works fine just a bit slow
_________________
http://www.waspmedia.co.uk |
|
|
|
