Avatar of udhna
udhna
Flag for India 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)
DatabasesDelphi

Avatar of undefined
Last Comment
FactorB

8/22/2022 - Mon
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/
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
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

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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