你可以这样:
query1.sql.add('select IPaddress,jihao from jifang where IPaddress='+''''+RemoteIP+'''');
query1.sql.add('select IPaddress,jihao from jifang where IPaddress='+''''+RemoteIP+'''');
调试欢乐多
比如,你开始的sql语句是这样的:select IPaddress,jihao from jifang where IPaddress=16.102.92.201
这明显不对。
试一试楼上的,或:
'select IPaddress,jihao from jifang where IPaddress='+chr($27)+RemoteIP+chr($27)
至于
query1.sql.add('select IPaddress,jihao from jifang where IPaddress=:RIP');
query1.parambyname('RIP').asstring:=RemoteIP;
为什么出错,我在研究研究。
Query1.Params.CreateParam( ftString, 'RIP', ptInput );
query1.sql.add('select IPaddress,jihao from jifang where IPaddress=:RIP');
是:RIP前加空格,分隔处参数, 即where IPaddress = :RIP