Re: Multiple Update statements in the same trigger or procedure:

Louay, Your email address doesn't seem to work... ----- The following addresses had permanent fatal errors ----- <mob2222@intouch.com> You will need to post the example UPDATE that works on its own but fails in the trigger or stored procedure? Along with the table schemas for the tables that are referenced... Without this information, I don't think anyone will be able to help you. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: Louay Farag <mob2222@intouch.com> }Date: Wed, 18 Jun 1997 09:13:32 +0300 }X-Informix-List-Id: <news.39338> } }Defining nested SQL statements (e.g. Update statements) }works fine in the administrator, but when inserted inside }a trigger or a procedure, I always get a syntax error.!!! } }-- }Louay Farag }MIS Assistant Manager } }e-mail: mob2222@intouch.com } }MOBICA }37, Al-Ahrar St. }Mohandissien }Cairo }Egypt