现在能否执行? 若不行,试: SqlStr := ' Select Info,anaend,digit,CallType From r_dnal where'+ ' digit=' + FilterString + ' and anaend<>'+IntToStr( R_DNAL_END_GOON )+' and entrance='+IntToStr(Entrance)+ ' and last>0';
本应该是digit='FilterString' 但是sql里不好区分所以外用单的里用双的
select '''' select '''''' select char(39)它是起转义的意思
'''' + FilterString + '''' 执行时就是 'FilterString '
SqlStr := ' Select Info,anaend,digit,CallType From r_dnal where digit=''' + FilterString + ''' and anaend<>'''+IntToStr( R_DNAL_END_GOON )+''' and entrance='''+IntToStr(Entrance)+ ''' and last>0';
若不行,试:
SqlStr := ' Select Info,anaend,digit,CallType From r_dnal where'+
' digit=' + FilterString +
' and anaend<>'+IntToStr( R_DNAL_END_GOON )+' and entrance='+IntToStr(Entrance)+ ' and last>0';
select ''''''
select char(39)它是起转义的意思
是不是就可以理解为和‘digit' + FilterString一样呢
digit=' + '"' + FilterString + '"'
真正的语句应当如此.
单引号中是一个双引号
得到的SQL应如下
digit="XXXXXXXX"
明白了吧!