RE: Strange ODBC error

Access is updating the entire row on the table, including the serial column. That is the problem - you cannot. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Andreas Schlegel > Sent: Tuesday, 17 June 2003 8:34 a.m. > To: informix-list@iiug.org > Subject: Re: Strange ODBC error > > > Jonathan Leffler wrote: > > Andreas Schlegel wrote: > > > > You have a table CREATE TABLE x (a SERIAL, b CHAR(10)); > > Your application does: > > > > UPDATE x SET a = <current-value-of-a>, b = <new-value-of-b> > > WHERE a = <current-value-of-a>;> No! I did: > > UPDATE x SET b = <new-value-of-b> > WHERE a = <current-value-of-a>;> > Well, this works ... if I send this statement. > > But if I edit a row in a linked Informix table in MS-Access > 2000 I get > the message: > "A SERIAL column (a) may not be updated. (#-232)" > > Of course I didn't updated the column a! I don't know what Access is > doing in the background when I edit a row of a linked table. > May be it > is a problem of the ODBC driver or of configuration. > > Hope somebody has a good idea. > > I just downloaded the current ODBC diver: 3.82.0000 2.81.TC1. > But the is > still there. > The Access-Client runs on Win98, the Informix IDS 7.3.1 on Linux. > > Greetings, > Andreas >

Murray Wood wrote: > Access is updating the entire row on the table, including the serial column. > That is the problem - you cannot. It seems so. But the behaviour of Access can be different. If I start the same operation on SQL Server 2000 everything runs as expected! So, in my humble opinion it must be a failure of the ODBC driver!? Greetings, Andreas

Hi Andreas, >UPDATE x SET b = <new-value-of-b> >WHERE a = <current-value-of-a>;> >Well, this works ... if I send this statement. > >But if I edit a row in a linked Informix table in MS-Access 2000 I get >the message: >"A SERIAL column (a) may not be updated. (#-232)" What exactly do you mean by edit a row? Are you running an update query or opening the linked table from the tables list and using the table editor to update the linked table when you have this problem? I tried using the table editor on a linked table to my IDS 9.30 db using CSDK 2.81 version of ODBC driver and also 2.70 version and did not get this message unless I specifically tried to update the serial col. Only difference other than server is that I was using MS Access 2002 SP2 (Office XP). Sounds to me like it might be a problem with version of Access you are using. I have a version of MS Access 2000 on another machine at office so I can try it out tomorrow. Also you may want to check which office service packs you have installed for Office 2000. Could be a fix in a service pack for this problem??? Anyway, I'll let you know what I find and if you have Office XP available you may want to try it out. Gregg Walker "Andreas Schlegel" <schlegelaw@epost.de> wrote in message news:bcm6bl$mgq$03$1@news.t-online.com... > Murray Wood wrote: > > Access is updating the entire row on the table, including the serial column. > > That is the problem - you cannot. > It seems so. But the behaviour of Access can be different. If I start > the same operation on SQL Server 2000 everything runs as expected! > > So, in my humble opinion it must be a failure of the ODBC driver!? > > Greetings, > Andreas >