Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping & Parameters (97)

    Grouping & Parameters
    Hope someone can correct me on what I

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Grouping & Parameters (97)

    Your first of two statements should be used. The problem is in your LIKE statement. The format for a Like statement is:

    Like ('SomeValue')

    Try - Like ('*' & [FILE NAME like?] & '*')
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Grouping & Parameters (97)

    What kind of ODBC failure? What is the backend you are using ODBC to link to?
    It could be that your query is taking longer than the timeout period set for it (default is normally 60 seconds), if this is the case just up the timeout value of the query.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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