Please! Help me in searching a string as 'John

  • 12 years ago

     'i want to find a string as 'John

    'when i find record in the following way

    Private Sub Command1_Click()

    ADO.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DB\KST.mdb;Persist Security Info=False;"

    ADO.RecordSource = "SELECT * FROM tblSecurity WHERE [Password]= ''John'"

    ' the following error occour

    ' syntax error (missing operator)in query expression '[Password]="John"

    ADO.Refresh

    DG.Refresh

    End Sub

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Any fool can write code that a computer can understand. Good programmers write code that humans can understand.” - Martin Fowler