S
SmallA
Unregistered / Unconfirmed
GUEST, unregistred user!
我在插入记录时语句如下:
一: WITH Query do
begin
close;
sql.Clear;
sql.add('insert into table(aa,bb,cc) values('''+edit2.Text+''',');
sql.add(''''+edit3.text+''','''+ComboBox.Text+'''');
Execsql;
end
二:
WITH Query do
begin
close;
sql.Clear;
sql.add('insert into jsyuan((aa,bb,cc) valuesparam1,aram2,aram3)');
parameters.ParamByName('param1').value:=Edit2.Text;
parameters.ParamByName('param2').value:=Edit3.Text;
parameters.ParamByName('param3').value:=ComboBox.Text;
ExecSQL;
end;
F9后都报"syntax error in insert into statement",请指点
一: WITH Query do
begin
close;
sql.Clear;
sql.add('insert into table(aa,bb,cc) values('''+edit2.Text+''',');
sql.add(''''+edit3.text+''','''+ComboBox.Text+'''');
Execsql;
end
二:
WITH Query do
begin
close;
sql.Clear;
sql.add('insert into jsyuan((aa,bb,cc) valuesparam1,aram2,aram3)');
parameters.ParamByName('param1').value:=Edit2.Text;
parameters.ParamByName('param2').value:=Edit3.Text;
parameters.ParamByName('param3').value:=ComboBox.Text;
ExecSQL;
end;
F9后都报"syntax error in insert into statement",请指点