how does LIKE operator work?

Eglute

I want to write sql sentence with LIKE operator. I wrote this code:

Expand|Select|Wrap|Line Numbers

 Private Sub Command8_Click()

List1.Clear

Set db = OpenDatabase("the path of my database")

Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE '%Pet%';")

While Not rec.EOF

List1.AddItem rec!ID & "  " & rec!Vardas & "   " & rec!pavarde & "  " & rec!Data

rec.MoveNext

Wend

rec.Close

db.Close

End Sub

and my program does nothing. I don't undestand how does LIKE work?

markmcgookin

Quote:

Originally Posted by Eglute

I want to write sql sentence with LIKE operator. I wrote this code:

Private Sub Command8_Click()
List1.Clear
Set db = OpenDatabase("the path of my database")
Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE '%Pet%';")
While Not rec.EOF
List1.AddItem rec!ID & " " & rec!Vardas & " " & rec!pavarde & " " & rec!Data
rec.MoveNext
Wend
rec.Close
db.Close
End Sub

and my program does nothing. I don't undestand how does LIKE work?

Hi,

I developed a VB app in the compact framework for a PDA and using SQL Sever CE and not MS access, but when I was doing something like this, I used this format:

I am assuming that you have assigned "Pet" as a string variable or something

i.e.

Expand|Select|Wrap|Line Numbers

 
Dim Pet As String

Pet = "Dog"
 
etc...
 
Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE ' " & Pet & " ' ")

But I am not sure if that would be the same for an Access DB

Eglute

I didn't assign Pet as a variable because I think that it is only a string line I want to find in my database. Why need I to assign Pet as a variable? When I wrote this code in Access I wrote:

Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE "*Pet*"; ")

and the querry was good, but with visual basic it doesn't work. I don't understand why?

Killer42

Quote:

Originally Posted by Eglute

I didn't assign Pet as a variable because I think that it is only a string line I want to find in my database. Why need I to assign Pet as a variable? When I wrote this code in Access I wrote:

Set rec = db.OpenRecordset("SELECT * From asmenu_info WHERE asmenu_info.pavarde LIKE "*Pet*"; ")

and the querry was good, but with visual basic it doesn't work. I don't understand why?

Actually, I think you have the Like clause correct. It should work exactly the same from VB as when used directly in Access. However, I note that in your original post you have converted the asterisks to percent symbols. If you are still talking to an Access database, I believe you still need to use the asterisks.

how does LIKE operator work?

re: how does LIKE operator work?

re: how does LIKE operator work?

re: how does LIKE operator work?

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about