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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | PaulS | 2004-04-01 18:32:37 | stored procedures with parameters w/dotnet |
Previous Message | SZ?CS Gabor | 2004-04-01 13:56:57 | Re: Error Codes in 7.4 |