select * from db where db.string like 'abcdef'或者你是想跟变量相同的string值显示出来可以这样: Query.sql.add('select * from db where db.string = :mystring'); paramByName('MySTring').AsSTring := string;
试试 CString string("abcdef"); CString str; str="select * from db where string like "+string;
我的原意是这样的, 一个文本框,一个combine box,文本框的值送到str中,combine box的值送到str1中,combine box 中有三个值分别对应三个字段名, sql语句是: select * from db where str1 like 'str',想用一句语句代替三种查询
这样试一下 CString str; str="select * from db where "+str1+" like "+str;
Query.sql.add('select * from db
where db.string = :mystring');
paramByName('MySTring').AsSTring := string;
CString string("abcdef");
CString str;
str="select * from db where string like "+string;
sql语句是:
select * from db where str1 like 'str',想用一句语句代替三种查询
CString str;
str="select * from db where "+str1+" like "+str;