Results 1 to 2 of 2
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ADO and Access query wildcards (2000/XP)

    Thanks, I'm sure this will help others - the difference can be bewildering!

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ADO and Access query wildcards (2000/XP)

    Edited by HansV to update URL and make it clickable - see <!help=19>Help 19<!/help>

    This isn't a question but the solution to a problem I had earlier today.
    I've had a quick search and didn't find anything here but apologies if I didn't look hard enough and this info is duplcated elsewhere in the lounge.

    I was opening a recordset in code using ado but it was returning EOF = True. The query forming the source of the recordset definitely contained records.
    I eventually realised this was because the WHERE criteria in the query contained the wildcard symbol * and ADO requires %.

    Changing the * to % in the query returned the correct number of records in the recordset.

    BUT opening the query from the databse window returned nothing <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    Eventually found this article Using the Right Wildcard Characters in SQL Statements

    And discovered changing the word 'Like' to 'ALike' allows the use of the ADO wildcard in the Access query grid <img src=/S/mice.gif border=0 alt=mice width=50 height=25>

Posting Permissions

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