Ok now i got the previous thing working i got a follow up question:
I wanted to use the query in my program
VB Code:
objData.SQL = "sp_ZoekKlantOpNaam" objData.InitializeCommand() objData.AddParameter("@KlantNaam", Data.OleDb.OleDbType.VarChar, txtZoekKlant.Text.Length, _ "*" & txtZoekKlant.Text & "*") objData.OpenConnection() objData.DataReader = objData.Command.ExecuteReader
The addparameter is just a functions that grabs the content of the textbox and passes it to the query, this works fine, used it lots of times in my project.
So whan i entered *pee* in Acces i got a result from the query. Now when i do basicly the same but then from vb i get nothing
I also tried replacing * with % without any luck
Hope someone can help me





Reply With Quote