|
CustomerData->Part1Query->Active = false;
CustomerData->Part1Query->SQL->
Add("Select * from 분점A Where ID = :ID And 조번호 = :조번호");
CustomerData->Part1Query->ParamByName("ID")->AsString = aaa;
CustomerData->Part1Query->ParamByName("조번호")->AsString = k;
CustomerData->Part1Query->Prepare();
if(CustomerData->Part1Query->Prepared) CustomerData->Part1Query->ExecSQL();
CustomerData->Part1Query->Active = true;
PartEdit2[i][j]->Text = CustomerData->Part1Query->FieldByName("상세")->AsString;
PartEdit[i][j]->Text = CustomerData->Part1Query->FieldByName("출고날짜")->AsString;
PartEdit1[i][j]->Text = CustomerData->Part1Query->FieldByName("입고날짜")->AsString;
위와 같이 할때는 에러가 나지 않습니다.......하지만 밑에걸 사용할때는
CustomerData->Part1Query->Active = true; 이부분에서
"Error Creating Cursor Handle"이라는 문구의 런타임에러가나네요.........
위와 밑이 틀린것은 위에는 select 쿼리문이고
밑에것은 update 쿼리문이라는 것입니다.
조언바랍니다...............
CustomerData->Part1Query->Active = false;
CustomerData->Part1Query->SQL->Clear();
CustomerData->Part1Query->SQL->
Add("UpDate 분점Z Set 입고날짜 = :입고날짜 Where ID = :ID And 조번호 = :조번호");
CustomerData->Part1Query->ParamByName("입고날짜")->AsString = TakeEdit->Text;
CustomerData->Part1Query->ParamByName("ID")->AsString = bbb ;
CustomerData->Part1Query->ParamByName("조번호")->AsString = Part_Take->TakeCombo->Text;
CustomerData->Part1Query->Prepare();
if(CustomerData->Part1Query->Prepared) CustomerData->Part1Query->ExecSQL();
CustomerData->Part1Query->Active = true;
|