MS ACCSS wierd problem..
Niraj Sinha got ODBC error 232 (a SERIAL column may not be updated) when updating a char column of a linked table through MS Access. Brett Randall asked for versions and schema and advised capturing the statement with onstat -g ses. tsutoo reported the problem with Access 2000 but not Access 97. falco said Access likely sends the serial field and suggested onstat -g sql.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
hi Guys, I am having problem in updating one of our tables through MSACCSS. Let us say that the table name is ACCOUNT and the schema is : accountnum serial not null, firmnum integer not null, accountname char(10) not null, . . . . .. ) Now when I go to update the accountname which is a char data type, I get the following error : ODBC --call failed [Informix][Informix ODBC Driver][Informix]A SERIAL column (accountnum) may not be updated (#232) This is driving us crazy. I am trying to updae char data type, and due to some reason it is updating the serial data type. This is not through any MSACCSS designed form. This is just adfter linking the table and trying to update. Any ideas ??? Thanks in advance. Niraj
"Sinha, Niraj" wrote:
>
> hi Guys,
>
> I am having problem in updating one of our tables through MSACCSS.
> Let us say that the table name is ACCOUNT and the schema is :
Version numbers of both Informix and M$ Access would be nice.
>
> accountnum serial not null,
> firmnum integer not null,
> accountname char(10) not null,
> .
> .
> .
> .
> ..
> )
>
Proper (entire) schema please! Constraints, indexes, keys etc.
> Now when I go to update the accountname which is a char data type,
> I get the following error :
How are you attempting the update? Details please.
>
> ODBC --call failed
> [Informix][Informix ODBC Driver][Informix]A SERIAL column (accountnum)
> may not be updated (#232)
Which ODBC Driver/version are you using?
>
> This is driving us crazy. I am trying to updae char data type, and due
> to some reason it is updating the serial data type.
> This is not through any MSACCSS designed form. This is just adfter
> linking the table and trying to update.
>
> Any ideas ???
Nothing concrete. I would verify that Access is not trying to update
the serial column accountnum. It probably is for whatever reason (hence
the error). You could try and capture the session using onstat -g ses
on the dbserver to see what the update statement is.
>
> Thanks in advance.
>
> Niraj
Regards
Brett Randall
Hi Sinha. Sorry my poor English.(Because I am Japanese.) I have similar experience. Here is my environment. +---------------+-----------------------+-----------------------+ | | I-CONNECT 2.40.TC1/ | I-CONNECT 2.50.TC2/ | | | Informix ODBC 3.31 | Informix ODBC 3.32 | +---------------+-----------------------+-----------------------+ | MS Access 97 | OK | OK | +---------------+-----------------------+-----------------------+ | MS Access 2000| NG | NG | +---------------+-----------------------+-----------------------+ OS : NT 4.0(SP5) Please try MS Access 97. In article <90qttq$mts$1@news.xmission.com>, "Sinha, Niraj" <niraj.sinha@BondBook.com> wrote: > > hi Guys, > > I am having problem in updating one of our tables through MSACCSS. > Let us say that the table name is ACCOUNT and the schema is : > > accountnum serial not null, > firmnum integer not null, > accountname char(10) not null, > . > . > . > . > .. > ) > > Now when I go to update the accountname which is a char data type, > I get the following error : > > ODBC --call failed > [Informix][Informix ODBC Driver][Informix]A SERIAL column (accountnum) > may not be updated (#232) > > This is driving us crazy. I am trying to updae char data type, and due > to some reason it is updating the serial data type. > This is not through any MSACCSS designed form. This is just adfter > linking the table and trying to update. > > Any ideas ??? > > Thanks in advance. > > Niraj > > -- Tsutomu Ogiwara from Japan. Sent via Deja.com http://www.deja.com/
hi.
You must make sure you're not sending any values to the 'accountnum' field
in your update.
Serial-type field isn't allowed to be edited, and Access is 'assuming' a lot
of things when using
the GUI tools, and is known to produce some very strange SQL-code in the
end.
Use the 'onstat -g sql' to look at the actual code you're sending, to see if
access tries to update
that accountnum-field.
/falco