Results 1 to 4 of 4

Thread: ADO Find

  1. May 26th, 2001, 08:24 AM #1
    Newbe0n
    Newbe0n is offline

    Thread Starter
    New Member
    Join Date
    Feb 2001
    Location
    Yorkshire, England
    Posts
    14

    Smile ADO Find

    Hi

    I am wanting to use the ADO find command.

    To search for records based on one criteria seems easy enough:

    myRS.Find ("Field1 = 'xxxxx'")

    But how do you put criteria in for multiple fields

    i.e. field1 = 'xxxxxxx' and field2 > 111111 etc.

    Thanks in advance
    Reply With Quote Reply With Quote
  2. May 26th, 2001, 12:59 PM #2
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    Uset the recordset's filter method, which allows for multiple conditions.
    Reply With Quote Reply With Quote
  3. May 27th, 2001, 04:42 AM #3
    Gush
    Gush is offline
    Hyperactive Member
    Join Date
    May 2001
    Location
    Beirut, Lebanon
    Posts
    318
    Lethal is right

    You cannot use the ADO Find method with multiple fields criteria.

    So use the filter property
    Reply With Quote Reply With Quote
  4. May 28th, 2001, 02:50 AM #4
    stm
    stm is offline
    Hyperactive Member
    Join Date
    Mar 2001
    Posts
    416
    Hi,

    I met the same problem b4, and I've investigate the Seek method, and suprise that SQL 6.5 and 7.0 both don't support Seek even u have proper index created.

    I would like to know whether SQL 2000 support it or not?

    Thx
    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