prepared tables - field cannot be found

[Oliver]

Hello,

i'm not sure if i'm right here but i dont know where i could search for this problem... so maybe you can help me:

Code: Select all

tQryFindKey->SQL->Clear();
   tQryFindKey->SQL->Add((AnsiString)"select keyword, id from keyword where upper(keyword) like upper(:Keyword)");

Code: Select all

            DlgMain->tQryFindKey->ParamByName("Keyword")->AsString = "test";
            DlgMain->tQryFindKey->SQL->Text;
            DlgMain->tQryFindKey->Execute();
            int tmp_Key = DlgMain->tQryFindKey->FieldByName("ID")->AsInteger;

i absolutly dont know why but when i create/edit an entry everything works fine, but when deleting one of them, i get an error after trying to save the new entry (tQryFindKey: the field 'ID' cannot be found).
when i'm using plsql developer i get an id and a keywordfield :/

maybe there's a known problem or something that i forgot (eg. the tables are prepared, do i need to close them after each execute() ?)

LG

oliver

[Alex]

Sorry, we cannot reproduce your problem. We need more detailed description i.e. your Oracle client/server versions, ODAC version, complete sample to demonstrate your problem and script to create server objects.
Please, send a message to our ODAC support e-mail address.