On Thursday 08 April 2004 13:23, Philippe Lang wrote:
> With the table described below, imagine I do, from the client:
> insert into test (code) VALUES (20);
> How does the client know the id that has been given to the record? With
> ethereal, I could see Access fetches the id by doing a
> select id from test where code = 20"
> Of course, another record has the same code, and the wrong id is being
> fetched back. This explains what I have noticed, and that is explained
Do you not have a primary key on your table?
In response to
pgsql-odbc by date
|Next:||From: Richard Combs||Date: 2004-04-08 15:21:27|
|Subject: Re: Access - ODBC - serial problem...|
|Previous:||From: Philippe Lang||Date: 2004-04-08 12:23:57|
|Subject: Access - ODBC - serial problem...|