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

Problem with DELETE instruction and ODBC

From: Nicolas GIMMILLARO <nicolas(dot)gimmillaro(at)wmi(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problem with DELETE instruction and ODBC
Date: 2004-04-01 16:52:41
Message-ID: 406C48D9.8020909@wmi.fr (view raw or flat)
Thread:
Lists: pgsql-odbc
Sine I've installed psqlodbc version 07.03.0200 I have error while 
trying to delete records from empty tables.

"DELETE FROM test" works if the table contains records, but if it is 
empty, MSACCESS return "no current record" (direct sql query)

The same query in delphi (4 and 7) has the same behavior. No error if 
the table contains records, and "Erreur de séquence de la fonction" (in 
french, sorry) if the table is empty.

Structure of the "test" table :

CREATE TABLE test (
    id integer NOT NULL,
    attrib character varying(250)
);



Versions affected :
PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
PostgreSQL 7.3.6 on i686-pc-linux-gnu, compiled by GCC 2.7.2.3

Any idea ?

Nicolas


pgsql-odbc by date

Next:From: PaulSDate: 2004-04-01 18:32:37
Subject: stored procedures with parameters w/dotnet
Previous:From: SZ?CS GaborDate: 2004-04-01 13:56:57
Subject: Re: Error Codes in 7.4

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