Re: [firebird-support] Update only changed tuple/ execute if-statement via execute statement?

2014-06-02 Thread eric wulfhekel eric.wulfhe...@gmail.com [firebird-support]
Thank you very much for your arguments/tips. Pity that there is no more perfomant general trigger - approach. But recreating triggers - maybe over stored procedures - is also a possibility for me. Thank you. Eric 2014-05-30 17:08 GMT+02:00 Ann Harrison aharri...@ibphoenix.com

[firebird-support] Update only changed tuple/ execute if-statement via execute statement?

2014-05-30 Thread eric wulfhekel eric.wulfhe...@gmail.com [firebird-support]
Hello, I would be very happy if anybody could help me. I want to create a update trigger which sets the current date to a field modified if values has changed. I have a lot of tables with a lot of columns so i want to work with system table for that task. I build the if-statement within a select

RE: [firebird-support] Update only changed tuple/ execute if-statement via execute statement?

2014-05-30 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Hello, I would be very happy if anybody could help me. I want to create a update trigger which sets the current date to a field modified if values has changed. I have a lot of tables with a lot of columns so i want to work with system table for that task. I build the if-statement within a

Re: [firebird-support] Update only changed tuple/ execute if-statement via execute statement?

2014-05-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, May 24, 2014 at 8:51 AM, eric wulfhekel eric.wulfhe...@gmail.com [firebird-support] firebird-support@yahoogroups.com wrote: I want to create a update trigger which sets the current date to a field modified if values has changed. I have a lot of tables with a lot of columns so i want