当字符串内有'号时不能插入数据?如下
字符串Adotable1DESC.VALUE内的值,如果字段内的值有',例如,FRIAN'S ENRCY ,就无法插入ms-sqlserver内的表,请问如何修改??VAR
Accode,DESC:STRING;BEGINDESC:=Adotable1DESC.VALUE;ADOQUERY1.SQL.Text:='insert into T1 (Acode,DESC)VALUSE('''+Accode+''''''+DESC+''')
字符串Adotable1DESC.VALUE内的值,如果字段内的值有',例如,FRIAN'S ENRCY ,就无法插入ms-sqlserver内的表,请问如何修改??VAR
Accode,DESC:STRING;BEGINDESC:=Adotable1DESC.VALUE;ADOQUERY1.SQL.Text:='insert into T1 (Acode,DESC)VALUSE('''+Accode+''''''+DESC+''')
ADOQUERY1.SQL.Text:='insert into T1 (Acode,DESC)VALUSE('''+Accode+''','''+DESC+''')高手们!过来看看啊!
StringReplace('aa', '''', '''''', [rfReplaceAll]);
ADOQUERY1.SQL.Text:='insert into T1 (Acode,DESC)VALUSE('+QuotedStr(Accode)+','+QuotedStr(DESC)+')';