Hi
I am using open-dbexpress V2.07 compiled with D7C/S connecting to SAP DB 7.4.3 via SAP ODBC v7.03.04.
Everything seems to work OK except when I connect to a table that has several boolean fields I get
BindInteger called for non Integer column no 17 -
ORDINAL_POSITION
BindInteger without indicator var for nullable
column 7 - TYPE
The column refered to is always a boolean type (which I believe is translated into an integer by the driver) BUT is never the first boolean column diplayed.
EG The message above came from access the following
table CREATE TABLE "DBASYS"."CLOCKING" (
"BADGEID" Char (10)
ASCII,
"CLOCKINGDIRECTION" Char (1)
ASCII,
"CLOCKING"
Timestamp,
"TERMINALNAME" Char (16)
ASCII,
"EMPLOYEEID" Char (10) ASCII
NOT NULL,
"CORRECTCLOCKING" Timestamp
NOT NULL,
"CORRECTCLOCKINGDIRECTION"
Char (1) ASCII,
"AUTOAPPLIED" Boolean DEFAULT
FALSE,
"SUPERVISOR" Boolean DEFAULT
FALSE,
"TERMINAL" Boolean DEFAULT
FALSE,
"IGNORECLOCKING" Boolean
DEFAULT FALSE,
"AUTHORISEDBY" Char (10)
ASCII,
"AUTHORISATIONDATE"
Date,
"SUPERVISEDCLOCKINGDIRECTION"
Varchar (50) ASCII,
"ABSENCECODE" Char (3)
ASCII,
"INEVENT" Boolean NOT NULL
DEFAULT FALSE,
"OUTEVENT" Boolean NOT NULL
DEFAULT FALSE,
"PROCESSED" Boolean NOT NULL
DEFAULT FALSE,
"CANUSE" Boolean NOT NULL
DEFAULT TRUE,
"EVENTDATE"
Date,
"EVENTTIME"
Time,
PRIMARY KEY ("EMPLOYEEID",
"CORRECTCLOCKING")
)
Field 17 is INEVENT but it has already accepted 4 other boolean fields
The only difference
that I know of in the Boolean fields is that the original table definition up to
InEvent was done via DELPHI/ADO and everything after
was
added via alter
statements in SQL Studio.
Any
suggestions?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This e-mail is confidential, may contain proprietary information of the Cooper Cameron Corporation and its operating Divisions and may be confidential or privileged. This e-mail should be read, copied, disseminated and/or used only by the addressee. If you have received this message in error please delete it, together with any attachments, from your system. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
