like 后面如果是字符串需要带上',例如:select * from kf where kf.房间号 like '302' 数据库里如果kf的房间号字段是字符串类型就需要带上',如果是数字类型就不需要,从你写的看来是字符串类型的
在VB里用这个一定得用CHR(34)么
中的*号是什么意思我看了在SQL书上找了半天都没找到 有关的列子
不是,例如 Data1.RecordSource = "select * from kf where kf.房间号 like '" & text1.text & "' order by 房间号"
code=VB] Data1.RecordSource = "select * from kf where kf.房间号 like " + Chr(34) + "*" + Chr(34) + "order by 房间号"可以用以下替代:Data1.RecordSource = "select * from kf where kf.房间号 like ""*"" order by 房间号"但SQL语句中,实际应该是这样:Data1.RecordSource = "select * from kf where kf.房间号 like '*' order by 房间号" [/code]多个字符 * c*c代表cc,cBc,cbc,cabdfec等 它同于DOS命令中的通配符,代表多个字符。
数据库里如果kf的房间号字段是字符串类型就需要带上',如果是数字类型就不需要,从你写的看来是字符串类型的
有关的列子
Data1.RecordSource = "select * from kf where kf.房间号 like '" & text1.text & "' order by 房间号"
Data1.RecordSource = "select * from kf where kf.房间号 like " + Chr(34) + "*" + Chr(34) + "order by 房间号"可以用以下替代:Data1.RecordSource = "select * from kf where kf.房间号 like ""*"" order by 房间号"但SQL语句中,实际应该是这样:Data1.RecordSource = "select * from kf where kf.房间号 like '*' order by 房间号"
[/code]多个字符
*
c*c代表cc,cBc,cbc,cabdfec等
它同于DOS命令中的通配符,代表多个字符。