Re: psql commit

From: tony <bigtoehere_at_hotmail.com>
Date: Fri, 03 Mar 2006 11:00:03 -0400
Message-ID: <igig0255na98fbmu7abs6a9jtrb5v54pp7@4ax.com>

Thanks for the replies. The subject should say plsql....it was the end of a long day ; ) I'll try to explain my question more fully.

BEGIN
   IF X = '1' THEN

      UPDATE mytable
      SET   myfield = 1
      WHERE id=idIn;
 
      htp.print('Thank you!); 
   ELSE
      htp.print('Operation failed')

   END IF;
END Does the commit occur after the WHERE clause or not until END?

thanks again,
tony   Received on Fri Mar 03 2006 - 09:00:03 CST