Re: [GENERAL] Fwd: function for trigger

2014-11-07 Thread David G Johnston
avpro avpro wrote > Hi, > > I have this function > > CREATE OR REPLACE FUNCTION sumlast_func() > RETURNS trigger AS > begin > CASE > WHEN idcar = (select idcar FROM selectedcar) THEN > JOIN selectedcar ON selectedcar.idcar = actuals.idcar) > update actuals > set > comb = comb + (select combor fro

Re: [GENERAL] Fwd: function for trigger

2014-11-07 Thread Adrian Klaver
On 11/07/2014 07:07 AM, avpro avpro wrote: Hi, I have this function CREATE OR REPLACE FUNCTION sumlast_func() RETURNS trigger AS begin CASE WHEN idcar = (select idcar FROM selectedcar) THEN JOIN selectedcar ON selectedcar.idcar = actuals.idcar) update actuals set comb = comb + (select combor fr

[GENERAL] Fwd: function for trigger

2014-11-07 Thread avpro avpro
Hi, I have this function CREATE OR REPLACE FUNCTION sumlast_func() RETURNS trigger AS begin CASE WHEN idcar = (select idcar FROM selectedcar) THEN JOIN selectedcar ON selectedcar.idcar = actuals.idcar) update actuals set comb = comb + (select combor from combor_view where idlog = (select max(idlo