From: | Wolfgang Fuertbauer <w(dot)fuertbauer(at)eunet(dot)at> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3 |
Date: | 2002-01-08 09:24:57 |
Message-ID: | 5.1.0.14.0.20020108102055.009e7db0@mail.austria.eu.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Severity: Major
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) ????
Example code:
"Select * from umsatz where kdnr = 2" gives Error-Message: Data Type
mismatch in criteria expression.
Please help!
Best regards
Wolfgang
---------------------------------------------------------------------
Wolfgang Fürtbauer w(dot)fuertbauer(at)eunet(dot)at
Steinbichlstrasse 58d 07612/77620
A-4812 Pinsdorf
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2002-01-08 09:51:16 | Bug #555: Lock-problem via ODBC |
Previous Message | Michael Handler | 2002-01-07 20:30:26 | MACADDR type & 00:00:00:00:00:00 |