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

    Join Date
    Jul 2012
    Posts
    24
    Rep Power
    0

    Singleton query has multiple rows


    This error is preventing display of results of my select query. Has some setting changed on my system? Not aware of this response in the past.
  2. #2
  3. Lord of the Dance
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2003
    Posts
    3,706
    Rep Power
    1959
    You forgot to post the error message.
    Where do you receive error ? e.g. which application is running the code?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    24
    Rep Power
    0

    Singleton Query has Multiple Rows


    Sorry I'm still quite new to this forum. Posted a summary of the error message in subject of this thread.

    Running IB_SQL: interface to Firebird database. When query result is a single row, all is well. But if the result contains more than one row, I get the following message:

    ISC ERROR CODE 335544652

    ISC ERROR MESSAGE:
    multiple rows in singleton select

    Is there a way to get all rows in this situation, without generating the error?
  6. #4
  7. Lord of the Dance
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2003
    Posts
    3,706
    Rep Power
    1959
    Doing a search on google for the error code, I found the comment below which may be helpful:
    Originally Posted by http://tech.groups.yahoo.com/group/firebird-support/message/39878
    It sounds as though you are using the DSQL tab in IB_SQL. That tab is for
    executable queries. For SELECT queries, switch to the Cursor tab and paste
    your multi-row query there.

IMN logo majestic logo threadwatch logo seochat tools logo