有一字符串（一段SQL语句），怎样执行它，里面如有单引号怎么处理

[pawly]

[pawly]

up!!!

[leaf_cq]

string ls_sql, ls_col1, ls_col2
ls_sql = "insert into table_1 (col_1,col_2) values('a','b' )" // 多了个参数：'c'
//或者（ls_col1 = 'a', ls_col2 = 'b' 于其他地方赋值）
//ls_sql = "insert into table_1 (col_1,col_2) values( '" + ls_col1 + "', '" + ls_col2 + "' )"
//或者
//ls_sql = "insert into table_1 (col_1,col_2) values( ~"" + ls_col1 + "~", ~"" + ls_col2 + "~" )"

EXECUTE IMMEDIATE :ls_sql USING My_trans;
if my_trans.sqlcode <> 0 then
rollback using my_trans;
else
commit using my_trans;
end if

[pawly]

我是这样写的：
string ls_sql
ls_sql = "insert into a1_test (varchar) values('" + em_1.text + "');"
messagebox("ls_sql",ls_sql)
EXECUTE IMMEDIATE :ls_sql USING sqlca;
messagebox(string(sqlca.sqlcode),sqlca.sqlerrtext)
if sqlca.sqlcode <> 0 then
rollback using sqlca;
else
commit using sqlca;
end if
可是提示缺少SQL语句

[pawly]

up!!!

[leaf_cq]

ls_sql = "insert into a1_test (varchar) values('" + em_1.text + "');"
应该为：
ls_sql = "insert into a1_test (varchar) values('" + em_1.text + "')"
不要最后的分号

[xwmhn]

同意楼上leaf_cq的,也可以用：
SELECT * FROM Table1 WHERE Field1 = ''
ORDER BY Table1 ASC

[王集鹄]

单引号中两个单引号等于一个
SELECT * FROM Table1 WHERE Field1 = ''''
// ~~~~“'”

[hongerchen]

"SELECT * FROM Table1 WHERE Field1 = '" + '' "'"
//字符串内容是：SELECT * FROM Table1 WHERE Field1 = ''
是不是这样，试一试吧！

[pawly]

******是这样的*******
string ls_sql
ls_sql = "insert into table_1 (col_1,col_2) values('a','b','c');"

[pawly]

把上面一段语句执行