用参数吧
sql.add('insert into table(name) values(:name)');
sql.parambyname('name').asstring:=edit1.text;
sql.execsql;
sql.add('insert into table(name) values(:name)');
sql.parambyname('name').asstring:=edit1.text;
sql.execsql;
调试欢乐多
begin
sql.add('insert into table(name) values('+#39+edit1.text+#39+')');
sql.execsql;
end;
sql.add('insert into table(name) values('''+edit1.text+''')');
>>sql....
>>sql.execsql;
->query.parambyname('name').asstring;=edit1.text;
->query.execsql;