Re: bad systable on SE 5.0

Also sprach Nils.Myklebust@nmdata.com (Nils Myklebust) : :On Thu, 25 Jun 1998 18:49:49 GMT, davek@summitdata.com (David Kosenko) :wrote: :>You can update a serial field via sql. :They do. I allways got the following error message when trying: : :-232 A SERIAL column column-name may not be updated. : :You cannot alter the contents of a column with the SERIAL data type in :the UPDATE statement, even when the updating value is zero. (You can :specify a value of zero for a serial column when you use the INSERT :statement; the database server ignores the zero and inserts a :generated :number.) Revise the statement so that only nonserial columns are :updated. : :Somewhat irritating but still true. So it is. I stand corrected! Dave Dave Kosenko (posting from home) Currently teaching folks everything I know about Informix at Summit Data Group (an Informix Authorized Education Center) For more info, see http://www.summitdata.com ********** "Everybody plays the fool, sometimes."