Detecting fields changed on post
Posted: 25.01.2012, 14:31
Hello
i have a problem but i dont know if there is a solution. I have a table with controlling checks and when i post an update i cant detect if the post is correct or not (there is not OnPostAndCheckOk event because the onupdated is trigged before the database check is checked
).
I would like to email a message when a field changed with the old and new values (and dont send it if the check was erroneous) but i dont know how to control it.
I am using postgresql and i was trying it using default zeos and delphi components and with the notify/listen events but i cant pass params in the notify to get an universal notify mechanism....
Can anybody help me?
Best regards
Skaw
i have a problem but i dont know if there is a solution. I have a table with controlling checks and when i post an update i cant detect if the post is correct or not (there is not OnPostAndCheckOk event because the onupdated is trigged before the database check is checked
).I would like to email a message when a field changed with the old and new values (and dont send it if the check was erroneous) but i dont know how to control it.
I am using postgresql and i was trying it using default zeos and delphi components and with the notify/listen events but i cant pass params in the notify to get an universal notify mechanism....
Can anybody help me?
Best regards
Skaw