Wolfgang Fürtbauer (w.fuertbauer@eunet.at) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3
Long Description
created table umsatz:
fakt32=# \d umsatz
Table "umsatz"
Attribute | Type | Modifier
------------+-----------------------+----------------------------------------------------
inr | integer | not null default nextval('"umsatz_inr_seq"'::text)
kdnr | bigint | default 0
jahr | integer | default 0
menge | real | default 0
netto | real | default 0
nettostamm | real | default 0
kz | character varying(2) |
kolltext | character varying(30) |
agtext | character varying(30) |
rabproz | real | default 0
Indices: umsatz_kdnr_key,
umsatz_pkey
as you can see: field "kdnr" is defined as bigint;
using MsAccess as frontend; connecting tables via ODBC (Driver Version 7.1.9);
field "kdnr" is shown as type text length(19) ????
Sample Code
"Select * from umsatz where kdnr = 2" gives Error-Message: Data Type mismatch in criteria expression.
No file was uploaded with this report