asked on TIBOQUERY: DB_KEY not found
HI
I am having a strange problem, I am getting the following Error when Selecting records with a TIBOQuery. I am using FireBird 2.1.3, Delphi 7 and IBO 4.8.
Please let me know your comments and suggestions.
--------------------------
Error
--------------------------
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -206
Column unknown
ACTIVELIST.DB_KEY
At line 15, column 19
STATEMENT:
TIBOInternalDataset: "<TApplication>.DM.qryACTI
--------------------------
OK
--------------------------
Regards,
Vijesh V.Nair
(INDIA)
I am having a strange problem, I am getting the following Error when Selecting records with a TIBOQuery. I am using FireBird 2.1.3, Delphi 7 and IBO 4.8.
Please let me know your comments and suggestions.
--------------------------
Error
--------------------------
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -206
Column unknown
ACTIVELIST.DB_KEY
At line 15, column 19
STATEMENT:
TIBOInternalDataset: "<TApplication>.DM.qryACTI
--------------------------
OK
--------------------------
Regards,
Vijesh V.Nair
(INDIA)
DatabasesDelphi
Last Comment
FactorB
Also check if it's not a reserved word of some sort (DB_KEY)...
Try a simple Query like "SELECT * FROM TblName;", if it's no go, change TIBOQuery with ZeosLIB
http://sourceforge.net/projects/zeoslib/
http://sourceforge.net/projects/zeoslib/
ASKER
HI,
Thanks for the comments,
FactorB, There is no syntax error with SQL, I rechecked.also there is no field reference for DB_KEY.
senad:, I didnt made anything in with Name DB_KEY.
FactorB:Un fortunately I can't Replace the Controls.
Thanks for the comments,
FactorB, There is no syntax error with SQL, I rechecked.also there is no field reference for DB_KEY.
senad:, I didnt made anything in with Name DB_KEY.
FactorB:Un fortunately I can't Replace the Controls.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
There was a problem in complex cases where the KeyLinksAutoDefine with the DB_KEY wasn't getting handled just right and was failing to prepare. This has been resolved in IBO Sub-Release 3.4 Cf.
Source: http://www.ibase.ru/download/ReleaseNotes.rtf
Source: http://www.ibase.ru/download/ReleaseNotes.rtf
Regards,
B.