Re: Deleting all rows from standard (with loggin) table on IDS 9.40

Posted in 2006

Lukas Barton — Thu, 28 Sep 2006 13:33:41 +0200 — source: Usenet: comp.databases.informix

Keith Simmons wrote: > Why do you need two separate statements for update. As far as I can > see the second statement should work fine in Informix (although there > may be a typo after 'select' ;-) ) > I'am sorry for posting HQL instead of SQL statement. The second statement in SQL is: update Dotaz as dotaz set statusId=:status, metaTypChyby=:metaTypChyby where dotaz.davka=:davka and dotaz.id in (select dotaz1.id from IdfKlient as vstp join Dotaz as dotaz1 on vstp.dotazid=dotaz1.id where dotaz1.davka=:davka and vstp.tabulkaVSablone=:tabulka)