TalkContent:=Memo_content.Text;sql:='insert into TBL_TalkContent_log(Caller,CallTime,SlicID,TalkContent) values('''+PhoneNum.text+''','''+CallTime+''','''+LoginForm.SlicID+''','''+TalkContent+''')';DM.ADOCommand.CommandText:=sql;DM.ADOCommand.Execute;代码如上,但是如果TalkContent里面有不能对的单引或者双引号就报语法错误,但是那些引号是必须的。
谁知道怎么解决啊!谢谢了!
谁知道怎么解决啊!谢谢了!
显示“在此上下文中不允许使用"dfsadf''dd,此处只能只用常量或表达式之类的话”
如果只能输入数字的话,可以
if not (Key in ['0'..'9', Char(VK_BACK)]) then
begin
if not (key in ['0'..'9','.',#13,#8]) then
begin
key:=#0;
showmessage('只能输入小数点和数字!');
end;
end;
SysUtils;
.....TalkContent:=StringReplace(Memo_content.Text,''','''',[rfReplaceAll]);sql:='insert into TBL_TalkContent_log(Caller,CallTime,SlicID,TalkContent) values('''+PhoneNum.text+''','''+CallTime+''','''+LoginForm.SlicID+''','''+TalkContent+''')';DM.ADOCommand.CommandText:=sql;DM.ADOCommand.Execute;
uses
SysUtils;
.....TalkContent:=StringReplace(Memo_content.Text,'''','''''',[rfReplaceAll]);sql:='insert into TBL_TalkContent_log(Caller,CallTime,SlicID,TalkContent) values('''+PhoneNum.text+''','''+CallTime+''','''+LoginForm.SlicID+''','''+TalkContent+''')';DM.ADOCommand.CommandText:=sql;DM.ADOCommand.Execute;
'+quotedstr(phonenum.text)+',下面的都这样该。或者用参数。
用quotedstr(phonenum.text)