如何用sql往数据库里存数据?
我写以下代码:
Query1->Active=false;
Query1->SQL->Clear();
Query1->SQL->Add("INSERT INTO animals.DBF (NAME, SIZE1, WEIGHT, AREA)");
Query1->SQL->Add("VALUES (:Name,:Size1,:Weight,:Area)");
//Query1->Prepared=true;
Query1->Prepare();
Query1->Params->Items[0]->AsString = frmAdd->edName->Text;
Query1->Params->Items[1]->AsFloat =frmAdd->edSize->Text.ToDouble();
Query1->Params->Items[2]->AsFloat = frmAdd->edWeight->Text.ToDouble();
Query1->Params->Items[3]->AsString =frmAdd->edArea->Text;
Query1->ExecSQL();
Query1->UnPrepare();
出现List index out of bounds(0)的错误,不知何故,请各位大侠不惜赐教。多谢