|
TQuery가 close되어 있는데..
어떻게 저장이 되나요..
close 하고.. execsql은 빼세요..
ball... 님이 쓰신 글 :
: 데이타베이스에 저장을 하거든여.
:
: WordInputForm->WordInputQuery->Close();
: WordInputForm->WordInputQuery->Append();
: WordInputForm->WordInputQuery->ParamByName("Use_code")->AsString = "01198224330";
: WordInputForm->WordInputQuery->ParamByName("Use_Name")->AsString = KoreaWordInputEdit->Text;
: WordInputForm->WordInputQuery->ParmaByName("Use_SE")->AsString = Memo2->Lines->Text;
: WordInputForm->WordInputQuery->ParamByName("UF")->AsString = Edit2->Text;
: WordInputForm->WordInputQuery->ParamByName("BT")->AsString = Edit3->Text;
: WordInputForm->WordInputQuery->ParamByName("NT")->AsString = Edit4->Text;
: WordInputForm->WordInputQuery->ParamByName("RT")->AsString = Edit5->Text;
: WordInputForm->WordInputQuery->ParamByName("LK")->AsString = Edit6->Text;
: WordInputForm->WordInputQuery->ParamByName("ATT")->AsString = Edit7->Text;
: WordInputForm->WordInputQuery->ParamByName("PERIOD")->AsString = Edit8->Text;
: WordInputForm->WordInputQuery->ParamByName("TI ")->AsString = Edit9->Text;
: WordInputForm->WordInputQuery->Post();
: WordInputForm->WordInputQuery->ExecSQL();
:
: 버튼을 누르면 이구문을 수행하게 해서 각 에디터들의 텍스트를 받아서 저장할려구 하는데
:
: 에러가 나는군여.... 그래서 이방식도 해봤는데 역시 에러.....
:
: WordInputForm->WordInputQuery->Close();
: WordInputForm->WordInputQuery->SQL->Clear();
: WordInputForm->WordInputQuery->SQL->Add("Insert into usetable ");
: WordInputForm->WordInputQuery->SQL->Add("(Use_code, Use_Name, Use_SE, UF, BT, NT, RT, LK, ATT, PERIOD, TI)" );
: WordInputForm->WordInputQuery->SQL->Add("Values ( '01198984330', '" + KoreaWordInputEdit->Text +"' ," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Memo2->Lines->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit2->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit3->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit4->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit5->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit6->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit7->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit8->Text +"'," );
: WordInputForm->WordInputQuery->SQL->Add("'" + Edit9->Text +"' )" );
: WordInputForm->WordInputQuery->ExecSQL();
: WordInputForm->WordInputQuery->Open();
:
: 무엇이 잘못된건지 조언좀..... 급변 부탁드립니다.
:
|