数据库查找。。。。分都给你了。。。
joo 2001-07-20 02:09:46 Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.Command
cn.ConnectionString = "uid=admin;pwd=;driver={microsoft access driver (*.mdb)};dbq=c:\joo\vb\temp\db\total.mdb"
cn.Open
cmd.CommandText = "SELECT * FROM tbl_1 WHERE CONTAINS( jz_no, '" & grid3_key1 & "' )"
cmd.ActiveConnection = cn
rs.Open cmd
如:我给 grid3_key1 赋值 1-3
但是编译是提示的错误信息是:
[microsoft][ODBC microsoft access driver] syntax error(missing operator)
in query expression CONTAINS(jz_no,'1-3').
请问 cmd.CommandText 那里有错。。。? CONTAINS()怎么用。。??