DB Inbound – Fail to convert resultset to row set

Clovertech Forums Cloverleaf DB Inbound – Fail to convert resultset to row set

  • Creator
    Topic
  • #122119
    Peter Heggie
    Participant

      I am using a DB Inbound protocol and using a SQL statement, not a stored procedure. The SQL is a SELECT. The format is SELECT tablename.columnname, tablename.columnname, ……. WHERE tablename.columnname = ‘value’.

      The invocation returns “Fail to convert resultset to row set:Index: 123, Size: 123”. What part is the resultset and what part is the row set? I am selecting specific columns, why would that cause some kind of indexing / number-of-items problem?

       

      Peter

      Peter Heggie
      PeterHeggie@crouse.org

    Viewing 0 reply threads
    • Author
      Replies
      • #122120
        Jim Kosloskey
        Participant

          Peter,

          I am curious if you tried this select outside of Cloverleaf (with something like DB Analyzer)?

          If so, did that return multiple elements in the result set? Are you configured to handle multiple elements in the result set?

          If you are configured for multiple elements in the result set, how is that configuration defined?

          Jim

          email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 60 years IT – old fart.

      Viewing 0 reply threads
      • You must be logged in to reply to this topic.