can not use like in sql??? - AndreaVB Visual Basic and VB.NET source code discussion board

AndreaVB Forum : Database : can not use like in sql??? Solved Topic

Poster

Message

luckyboy
Level: VB Lord

Registered: 05-05-2005
Posts: 160

can not use like in sql???

hi all. i can't used like in sql statement.
here my code:
rs.filter="Last_Name LIKE '" & Me.txtLastName& "%'"
error message:
agument are of the wrong type. anyidea?

____________________________
Please help out.

02-06-2006 at 12:37 PM

stickleprojects
Level: Moderator

Registered: 09-09-2002
Posts: 891

Re: can not use like in sql???

Hi,
Try "*" rather thsn "%"
K

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

02-06-2006 at 11:47 PM

luckyboy
Level: VB Lord

Registered: 05-05-2005
Posts: 160

Re: can not use like in sql???

many thank to you stickleprojects. but it is still the same error. now i decided to stop using filter in this case and used rs.open instead. because it always fine.

____________________________
Please help out.

03-06-2006 at 02:51 AM

AndreaVB Forum : Database : can not use like in sql??? Solved Topic


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincani