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.qryACTIVELIST.IBOqrqryACTIVELIST."

---------------------------
OK
---------------------------

Regards,
Vijesh V.Nair
(INDIA)

FactorB

What's the query you are posting to the server, maybe there is SQL syntax error?

Regards,
B.

senad

Also check if it's not a reserved word of some sort (DB_KEY)...

FactorB

Try a simple Query like "SELECT * FROM TblName;", if it's no go, change TIBOQuery with ZeosLIB

http://sourceforge.net/projects/zeoslib/

udhna

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.

ASKER CERTIFIED SOLUTION

udhna

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

FactorB

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