Clovertech

James Sedlmeyer

Forum Replies Created

Viewing 8 replies – 1 through 8 (of 8 total)
  • Author
    Replies
  • January 6, 2010 at 6:47 pm in reply to: ODBC #70390
    James Sedlmeyer
    Participant

      Jim

      Again thanks for your help. The stored procedure now has OUTPUT applied to the fields that are returned to my odbc call. It looks like I’m getting farther. My script is currently ends where I’m checking for number_of_results just after the call to the stored procedure. I’m hard coding input values to the SP that I’m told are in the database. However I’m still getting zero for number_of_results. Below is the information returned after my odbc sp call.

      Connecting To The Database

      SQL_SUCCESS_WITH_INFO Successful Connection To Database

      SQL_SUCCESS Sql Statement Handle Allocated

      Prepare works

      BIND SUCCESS

      BIND SUCCESS

      BIND SUCCESS

      BIND SUCCESS

      BIND SUCCESS

      BIND SUCCESS

      BIND SUCCESS

      BIND SUCCESS

      BIND OF SQL_NUMERIC SUCCESS

      storedproc = spNDCTransform ‘06310270’, ‘5’, ‘7.00’, ‘OHAC’, ”, ”, ”, ”, ”;

      NDC: => Stored Proc Successful

      error = SQL_SUCCESS

      number of results = 0

      Attached is my proc. I’m sending 4 input parms and expecting 5 output parms returned. At this point I’m just trying to get a row of data returned. I’m told the record is in the db but I do not have access to confirm. I’m hoping it is now something I have wrong. Any suggestions would help.

      February 21, 2009 at 11:57 pm in reply to: SQLITE #66974
      James Sedlmeyer
      Participant

        Thanks Charlie. Great Stuff

        February 21, 2009 at 1:33 pm in reply to: SQLITE #66972
        James Sedlmeyer
        Participant

          Hi Jim

          List processing. Thats the direction I started going in. I was very surprised that there was no cursor functionality in sqlite but I’m not complaining because it’s free. Thanks for your response.

          March 6, 2008 at 5:41 pm in reply to: TCL Packages #64005
          James Sedlmeyer
          Participant

            Thanks for everyones help. Much appreciated.

            March 6, 2008 at 12:19 pm in reply to: TCL Packages #64002
            James Sedlmeyer
            Participant

              I’m looking for pointers on creating the packages.

              Thanks

              December 5, 2007 at 7:11 pm in reply to: Formating Report in FRL or VRL #63064
              James Sedlmeyer
              Participant

                Jim

                Thanks for your prompt response. I was just looking to be pointed in the right direction and you really helped.

                Jim

                May 4, 2007 at 5:03 pm in reply to: VRL to HL7 using fileset – local only passing one record #61273
                James Sedlmeyer
                Participant

                  Jim

                  Thanks for the response. I’ve got the problem solved. The newline chars were not being recognized. I used a proc that recognizes the newline chars that I placed in the directory parse parameter.

                  Thanks

                  Jim

                  April 30, 2007 at 4:54 pm in reply to: Stripping out quotation marks #57099
                  James Sedlmeyer
                  Participant

                    Mark

                    How did this work for you

                    Thanks

                    Jim

                  • Author
                    Replies
                  Viewing 8 replies – 1 through 8 (of 8 total)