Results 1 to 2 of 2

Thread: SQL Escape Character Jet OLEDB 4.0

  1. Sep 23rd, 2000, 03:14 AM #1
    Egg
    Egg is offline

    Thread Starter
    New Member
    Join Date
    Sep 2000
    Posts
    8

    Angry

    A question regarding SQL using Jet OLE DB 4.0

    I am trying to execute the following...

    With rsSearch
    'Get the number of records in the table
    .Open "Select * From " & sTable & "Where " & _
    sField & " Like '#_' Escape '#'"
    dbDatabase, _
    adOpenKeyset, _
    adLockOptimistic

    etc...

    The escape character does not work any solutions?
    Reply With Quote Reply With Quote
  2. Sep 23rd, 2000, 06:47 AM #2
    Egg
    Egg is offline

    Thread Starter
    New Member
    Join Date
    Sep 2000
    Posts
    8
    Dont worry guys I worked it out. Thanks anyway.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width