|
: ADOQuery1->Close();
: ADOQuery1->SQL->Clear();
: ADOQuery1->SQL->Text="Update Apply Set check='' Where check='c'";
: ADOQuery1->ExecSQL();
저는 이렇게 사용합니다
AnsiString SQLStr;
SQLStr = "Update Apply Set check=:check Where check=:w_check";
ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add(SQLStr);
ADOQuery1->Parameters->ParamByName("check")->DataType = ftString;
ADOQuery1->Parameters->ParamByName("w_check")->DataType = ftString;
ADOQuery1->Parameters->ParamByName("check")->Value = " ";
ADOQuery1->Parameters->ParamByName("w_check")->Value = "c";
ADOQuery1->ExecSQL();
|