sql problem

[spoofer]

I know this is not really a vb.net problem
but since i will be using the query in my program...

Anyway when i run this query in the picture below i don't get any result, when i should be getting one result. I just don't get what i'm doing wrong

Thanx a lot

[szlamany]

Ok - let's make sure we don't have some silly problem - like wrong DB open or something like that...

Will this work?

Select * from tblKlant Where KlantNaam='Peeters'

If so will this then work?

Select * from tblKlant Where Left(KlantNaam,3)='Pee'

What is the datatype of that column - some datatypes will not work with the LIKE operator...

[spoofer]

Jup they both work
It's a regular text field.

I just don't se what i'm doing wrong, the like looks good to me..but no result

[szlamany]

Jup they both work
It's a regular text field.

Ok - is this MS SQL SERVER as the backend database...

And you mean the datatype is TEXT (as opposed to VARCHAR or CHAR)...

[spoofer]

It's just MS Access database

Hope you can help me, thx

[GaryMazzone]

Is this being done in Access or VB and the query is being run against access? If completely in MS Access then you need to replace the normal SQL wild card character ( % ) with the Access wild card character ( * ).

[spoofer]

haha thanx Gary
I knew it was something small

[spoofer]

Ok now i got the previous thing working i got a follow up question:
I wanted to use the query in my program

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

[spoofer]

nvm worked around this, just created the query in vb