prepared tables - field cannot be found
Posted: Mon 07 Nov 2005 10:27
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:
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
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;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