unknown column error / D7
Posted: Fri 29 Jul 2011 14:14
Hi,
with the new update v4.90 every TSQLDataSet produces
an "unknown column ...' error.
with persistent fields we got:
"different types for field 'ID'; expected: integer; found BCD"
with the last used version 4.70.XX and with the new versions
for FireBird/Interbase and MS-SQL everything works like before.
we read the connection parms from an ini file:
...
BlobSize=-1
DataBase=ORA8
ErrorResourceFile=
LocaleCode=0000
Password=****
Oracle TransIsolation=ReadCommited
RoleName=Normal
User_Name=USER
LongStrings=True
InternalName=
UseQuoteChar=False
UseUnicode=False
FetchAll=False
CharLength=0
Charset=WE8ISO8859P1
BCDPrecision=0
FloatPrecision=38
IntegerPrecision=10
Simple sample to reproduce
CREATE TABLE TEST
(
ID NUMBER(10,0),
ID_1 NUMBER(10,0) NOT NULL,
ID_2 NUMBER(10,0) NOT NULL,
FORM_NAME VARCHAR2(40),
CONSTRAINT TEST_PK
PRIMARY KEY (
ID
) ENABLE VALIDATE
)......
select * from TEST where ID_1 = and ID_2 = :y and FORM_NAME = :z
Thomas
-------------------------
Delphi 7 ENT
Oracle 8.1.7.X.X
with the new update v4.90 every TSQLDataSet produces
an "unknown column ...' error.
with persistent fields we got:
"different types for field 'ID'; expected: integer; found BCD"
with the last used version 4.70.XX and with the new versions
for FireBird/Interbase and MS-SQL everything works like before.
we read the connection parms from an ini file:
...
BlobSize=-1
DataBase=ORA8
ErrorResourceFile=
LocaleCode=0000
Password=****
Oracle TransIsolation=ReadCommited
RoleName=Normal
User_Name=USER
LongStrings=True
InternalName=
UseQuoteChar=False
UseUnicode=False
FetchAll=False
CharLength=0
Charset=WE8ISO8859P1
BCDPrecision=0
FloatPrecision=38
IntegerPrecision=10
Simple sample to reproduce
CREATE TABLE TEST
(
ID NUMBER(10,0),
ID_1 NUMBER(10,0) NOT NULL,
ID_2 NUMBER(10,0) NOT NULL,
FORM_NAME VARCHAR2(40),
CONSTRAINT TEST_PK
PRIMARY KEY (
ID
) ENABLE VALIDATE
)......
select * from TEST where ID_1 = and ID_2 = :y and FORM_NAME = :z
Thomas
-------------------------
Delphi 7 ENT
Oracle 8.1.7.X.X