您所在位置：主题：请教一个简单问题
xinimud
[专家分：0] 发布于 2006-11-13 20:10:00
我刚学不久,遇到一个问题,请高手们帮帮忙(就是粗邪体这一段)
就是当format函数中的字符串中又包括'%'该怎么办,我是这么写的,老报错
if compare_sign=' like ' then
[i][b]sql_str:='select * from teacherinfo where %s%s''%'+'%s'+'%'''+ ' order by %s'[/b][/i]
else
sql_str:='select * from teacherinfo where %s%s''%s'' order by %s';
with teacherdm.teacherinfoadoqr do
begin
close;
sql.Clear;
sql.Add(format(sql_str,[key_sign,compare_sign,search_sign,key_sign]));
prepared;
open;
end;
就是当format函数中的字符串中又包括'%'该怎么办,我是这么写的,老报错
if compare_sign=' like ' then
[i][b]sql_str:='select * from teacherinfo where %s%s''%'+'%s'+'%'''+ ' order by %s'[/b][/i]
else
sql_str:='select * from teacherinfo where %s%s''%s'' order by %s';
with teacherdm.teacherinfoadoqr do
begin
close;
sql.Clear;
sql.Add(format(sql_str,[key_sign,compare_sign,search_sign,key_sign]));
prepared;
open;
end;
