#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    24
    Rep Power
    0

    Select multiple records


    The following select statements succeed:

    Select email from residents
    where kres in (26)

    Select email from residents
    where kres in (32)

    However, the following statement returns only record #26:

    Select email from residents
    where kres in (26, 32)

    Would you please show me what is wrong with this statement.

    TIA...
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    4
    Your statement is fine. Perhaps you simply fetch only the first record?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    24
    Rep Power
    0
    Right, forgot about navigating the result set.

    Does IB_SQL have a way to display the complete result set on one screen?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    13
    Does it have FetchAll method/option?

IMN logo majestic logo threadwatch logo seochat tools logo