unknown column error / D7
-
- Posts: 30
- Joined: Tue 27 Jun 2006 15:46
unknown column error / D7
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
Hello,
To solve this problem, try to set the EnableBCD property to false in the following way:
or starting from Delphi 2007
To solve this problem, try to set the EnableBCD property to false in the following way:
Code: Select all
procedure TForm1.SQLConnection1AfterConnect(Sender: TObject);
const
coEnableBCD = TSQLConnectionOption(102); // boolean
begin
SQLConnection1.SQLConnection.SetOption(coEnableBCD, Integer(False));
end;
Code: Select all
SQLConnection1.Params.Values['EnableBCD']:='false';
-
- Posts: 30
- Joined: Tue 27 Jun 2006 15:46
-
- Posts: 30
- Joined: Tue 27 Jun 2006 15:46