该怎么写呢? select * from ygda where ygda.姓名 in 后面该怎么写?
select * from table where name=#39+edit.text+#39
模糊查询?(比如:查出所有姓张的) 用'select * from ygda where ygda.姓名 like '+''''+trim(edit.text)+'%''' ;
//该怎么写呢? //select * from ygda where ygda.姓名 in //后面该怎么写? select * from ygda where ygda.姓名 in ("姓名1","姓名2","姓名3")
1.用ComboBox,按Ctrl+Ins添加一个姓名,按Ctrl+Del删除一个姓名 2.查询时,把Combobox.items.text用StringReplace函数把#$D#$A换成',' 付给一个变量vt, 3.然后'Select * from table where name in (' + vt + ')'; 4.然后……;
'select * from ygda where ygda.姓名 in ('+'''姓名1'''+','+'''姓名2'''+','+'''姓名3'''+')'; OK
select name from tablename where name = "+trim(edit.text)+"
select * from ygda where ygda.姓名 in
后面该怎么写?
用'select * from ygda where ygda.姓名 like '+''''+trim(edit.text)+'%''' ;
//select * from ygda where ygda.姓名 in
//后面该怎么写?
select * from ygda where ygda.姓名 in ("姓名1","姓名2","姓名3")
2.查询时,把Combobox.items.text用StringReplace函数把#$D#$A换成','
付给一个变量vt,
3.然后'Select * from table where name in (' + vt + ')';
4.然后……;
OK
from employee
where employee.name in ['x','y','z']
//
//select * from tablename where employee_name in ( 'x','y','z')
//
//
//
//
select * from tablename where employee_name in ( 'x' , 'y' , 'z' )
或作一个类似VB的Split()分割字符串函数。
这样都比较麻烦,换换别的方法吧!