Problem with ParamByName
Posted: Wed 14 Feb 2007 20:29
Hello,
I get the error Parameter iPK not found.
iPK = 3;
MyQuery1->SQL->Clear();
MyQuery1->Close();
MyQuery1->SQL->Add("delete from streets where PK = :iPK");
MyQuery1->ParamByName("iPK")->AsInteger = iPK;
MyQuery1->Execute();
What is wrong with this ?
I use BCB5, MySql 5 and CoreLab 5.00.0.1
Thanks,
Jan
I get the error Parameter iPK not found.
iPK = 3;
MyQuery1->SQL->Clear();
MyQuery1->Close();
MyQuery1->SQL->Add("delete from streets where PK = :iPK");
MyQuery1->ParamByName("iPK")->AsInteger = iPK;
MyQuery1->Execute();
What is wrong with this ?
I use BCB5, MySql 5 and CoreLab 5.00.0.1
Thanks,
Jan