Hi
I want to run an export of filtered records in status “X” and have the status update the status upon execution to “Y” and capture date.
Is this achievable?
Alternatively, and perhaps easier, How can I edit multiple records at once i.e.
Select Status column and change to “Y”
Select date & Change
Thanks
how about performing an update statement and then doing an sc_redir to the same page?
Can you give me a hint on how to do that please?
Editing multiple records at once how I think you could do it.
Suppose you have a record with 10 fields. Catch the OnChange event of the field you want to change.
In that OnChange event perform an update for the records you want changed:
then just do an update mytable set status=‘Y’ where status=‘X’ in an sql call (autocommit is assumed here).
after that simply sc_redir to the page you are already on.