[RESOLVED] Fox Pro Database SQL when using variables

[seanwpb]

i have a vb.net 2010 app i trying to connect a dbf file. i think its a fox pro database. i can connect to it fine and get all data from a column just fine. the problem is when i use the WHERE clause i dont know how to surround the variable since i have never used this type of database before now. this is what i have

Dim oCmdSelect As New OleDbCommand("SELECT LASTNAME, FIRSTNAME FROM UPDATED WHERE LASTNAME = lstItems1.Items(x).ToString, FIRSTNAME = lstItems2.Items(x).ToString", oAccessConn)

so the lstItems1.Items(x).ToString is a listbox entry. i basically have a list box with about 800 names. i what to open the database to see if they exist in it with i guess a while loop, not sure about that yet. but i have searched everywhere and i can find out how to surround the lstItems1.Items(x).ToString

[jggtz]

Chr(39) & lstItems1.Items(x).ToString & Chr(39)

[seanwpb]

JG,

thanks for the quick reply. this is what i have and the error follows

"SELECT LASTNAME, FIRSTNAME FROM UPDATED WHERE LASTNAME = Chr(39) & lstItems1.Items(x).ToString & Chr(39)"

error: command contains unrecognized phrase/keyword. any ideas?

[jggtz]

"SELECT LASTNAME, FIRSTNAME FROM UPDATED WHERE LASTNAME = " & Chr(39) & lstItems1.Items(x).ToString & Chr(39)

[seanwpb]

that was it. thank you so much