Problemas con LIKE
Buen día...
Tengo un problema con el siguienmte código:
Dim rproducts As Recordset
Dim rbuscar As Recordset
Private Sub Buscar_Click()
Dim i As Integer
Dim querystr As String
querystr = "Select * from products where (UPC like '%" & txtbuscar.Text & "%')"
Set rbuscar = Dbase.OpenRecordset(querystr)
rbuscar.MoveFirst
End Sub
El recordset queda con 0 registros y si miro en la tabla efectivamente hay registros que coinciden, estoy usando DAO 3.5 y SQL Server.
Gracias...
Tengo un problema con el siguienmte código:
Dim rproducts As Recordset
Dim rbuscar As Recordset
Private Sub Buscar_Click()
Dim i As Integer
Dim querystr As String
querystr = "Select * from products where (UPC like '%" & txtbuscar.Text & "%')"
Set rbuscar = Dbase.OpenRecordset(querystr)
rbuscar.MoveFirst
End Sub
El recordset queda con 0 registros y si miro en la tabla efectivamente hay registros que coinciden, estoy usando DAO 3.5 y SQL Server.
Gracias...
1 respuesta
Respuesta de xabi
1
No uso DAO pero:
Prueba a cambiar el % por un *
Dim rproducts As Recordset
Dim rbuscar As Recordset
Private Sub Buscar_Click()
Dim i As Integer
Dim querystr As String
querystr = "Select * from products where (UPC like '*" & txtbuscar.Text & "*')"
Set rbuscar = Dbase.OpenRecordset(querystr)
rbuscar.MoveFirst
End Sub
Prueba a cambiar el % por un *
Dim rproducts As Recordset
Dim rbuscar As Recordset
Private Sub Buscar_Click()
Dim i As Integer
Dim querystr As String
querystr = "Select * from products where (UPC like '*" & txtbuscar.Text & "*')"
Set rbuscar = Dbase.OpenRecordset(querystr)
rbuscar.MoveFirst
End Sub
