Results 1 to 3 of 3

Thread: MULTI find in sql server table

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Location
    Italy-Napoli
    Posts
    2,307

    MULTI find in sql server table

    I have this two var:

    Mydata As date
    Mystring as String

    I need to find if a pair of this two var are present in mytable based filed F1 (date filed) and F2 (string field)

    example:

    Mydata=18/06/2022
    Mystring="123456"

    F1 F2
    19/06/2022 123456
    18/06/2022 123456
    21/06/2022 123456

    in my case the relation is present in second row

    i can use SEEK, .find, .filter....or?

    note:
    i use CN as ado connection

  2. #2
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,166

    Re: MULTI find in sql server table

    Do you know how to write SQL queries?
    If not then start with some basic online tutorials, like w3schools

  3. #3
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    3,175

    Re: MULTI find in sql server table

    Yes, SQL is the way to go
    (and this thread to the Database-Forum)
    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

Posting Permissions

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



Click Here to Expand Forum to Full Width