Re: Trigger to create string to inverse SQL statement

2018-03-08 Thread Francisco Olarte
Jacek: On Thu, Mar 8, 2018 at 1:53 PM, Łukasz Jarych wrote: > maybe somebody wrote SP to invert update statement? Maybe, but if you are going to ask for it you better define the problem a little. Francisco Olarte.

Re: Trigger to create string to inverse SQL statement

2018-03-08 Thread Francisco Olarte
Hello: On Thu, Mar 8, 2018 at 1:51 PM, Łukasz Jarych wrote: > what do you mean use external program to build inverted queries. Do you have > any examples? Please, do not top quote, or the thread will get difficult to follow fast. That being said. Capturing a DML in a trigger is relatively easy

Re: Trigger to create string to inverse SQL statement

2018-03-08 Thread Łukasz Jarych
maybe somebody wrote SP to invert update statement? Best, Jacek 2018-03-08 13:51 GMT+01:00 Łukasz Jarych : > thank you, > > what do you mean use external program to build inverted queries. Do you > have any examples? > > Best, > Jacek > > 2018-03-08 13:44 GMT+01:00 Francisco Olarte : > >> Hello:

Re: Trigger to create string to inverse SQL statement

2018-03-08 Thread Łukasz Jarych
thank you, what do you mean use external program to build inverted queries. Do you have any examples? Best, Jacek 2018-03-08 13:44 GMT+01:00 Francisco Olarte : > Hello: > > On Thu, Mar 8, 2018 at 1:32 PM, Łukasz Jarych wrote: > >> >> >> i have a trigger which is added log history: >> >> >> >>

Re: Trigger to create string to inverse SQL statement

2018-03-08 Thread Francisco Olarte
Hello: On Thu, Mar 8, 2018 at 1:32 PM, Łukasz Jarych wrote: > > > i have a trigger which is added log history: > > > > ​I'll trust it is, but I cannot really see any thing in there, it may be better if in the future you used something like psql and pasted the data in a text format, which people

Trigger to create string to inverse SQL statement

2018-03-08 Thread Łukasz Jarych
Hello, i have a trigger which is added log history: It is possible to create additional column here with string with inversed SQL statement? So in this case: "Delete FROM t_trig WHERE ID=1". And what i want is to have possibility to loop through table and execute inversed sql statement for ea