这条SQL语名该怎么写?? 其中minprice是整数型
下面这样写总是出现错误!!
[Error] sys_Price_Find.pas(73): Incompatible types: 'String' and 'Integer''Select * from price where proName like '+''''+'%'+trim(proName.Text)+'%'+''''+' and price>'+''+minprice+''
下面这样写总是出现错误!!
[Error] sys_Price_Find.pas(73): Incompatible types: 'String' and 'Integer''Select * from price where proName like '+''''+'%'+trim(proName.Text)+'%'+''''+' and price>'+''+minprice+''
'String' and 'Integer'<------你的price是integer类型的
'Select * from price where proName like :par1 and price > :par2'
query.params[0].value := '....';
query.params[1].value := ...;
query.open;