ODBC Stored Procedure Call

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf ODBC Stored Procedure Call

  • Creator
    Topic
  • #51470
    James Sedlmeyer
    Participant

      I’m here again hoping someone can see something wrong with my ODBC script that calls a SQLSERVER stored procedure. At this point I’m just trying to get a returned row of data that I’m told is present in the database. The proc is sending 4 input parms and receiving 5 output parms from the stored procedure. After I execute the SP I’m just chaecking the SQLMoreResults field and am getting SQL_NO_DATA_FOUND. I’m meeting with the person who wrote the SP today but want to rule out it’s not something wrong with my script. I’ve attached the script again. Jim K has pointed me in the right direction but I’m still not there. Also does someone have a tcl/odbc script that sends and receives data to sqlserver that they would want to share???????

    Viewing 1 reply thread
    • Author
      Replies
      • #70424
        Tom Rioux
        Participant

          James,

          I’m attaching one that we are going to be implementing soon here.   It is complete yet.  I still have to do some error coding but it does return the rows, then takes the data and populates it into the message.

          I have to give props to Jim K as well because this was written from a template that he provided to me.   I have merely made some modifications where necessary.

          Let me know if you need any explanation of anthing.

          Thanks…..

          Tom Rioux

        • #70425
          Josh Lewis
          Participant

            From what I have found the command SQLMoreReults checks the result set to see if you have more than 1 returned set.  You should be able to use SQLFetch against your statement to see if there is data then mine the data from that point (I usually use SQLGetData).

            Hope this helps.

            Josh Lewis

        Viewing 1 reply thread
        • The forum ‘Cloverleaf’ is closed to new topics and replies.