SQL錯誤 發表人 - CJF 於 2002/12/06 09:56:22

附加檔案：23612_sql.exe

procedure TForm1.Button1Click(Sender: TObject); var str:string; begin query1.Close ; query1.SQL.Clear; str:='insert into data("客戶編號") values('#39 edit1.Text #39')'; // str:='insert into data(客戶編號,客戶名稱,型號,規格,品名,Iteam_Logo,內條碼,外條碼,生產地,備註,建檔日期) '; // str:=str ' values("' dbedit1.Text '","' dbedit2.Text '","' dbedit3.Text '","' dbedit4.Text '","' dbedit5.Text '","' dbedit11.Text '",'; // str:=str '"' dbedit6.Text '","' dbedit7.Text '","' dbedit9.Text '","' dbedit10.Text '","' dbedit8.Text '")'; query1.SQL.Add(str); query1.Prepare; query1.ExecSQL; end;