Skip site navigation (1) Skip section navigation (2)

Re: Access - ODBC - serial problem...

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access - ODBC - serial problem...
Date: 2004-04-08 13:48:53
Message-ID: 200404081448.53157.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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
> below...

Do you not have a primary key on your table?


-- 
  Richard Huxton
  Archonet Ltd

In response to

Responses

pgsql-odbc by date

Next:From: Richard CombsDate: 2004-04-08 15:21:27
Subject: Re: Access - ODBC - serial problem...
Previous:From: Philippe LangDate: 2004-04-08 12:23:57
Subject: Access - ODBC - serial problem...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group