Post reply

Query runs with error when passed parameters

  • January 8, 2013 at 9:48 am

    #1574912

    Brandie Tarvin (1/8/2013)

    GilaMonster (1/8/2013)

    I thought you said you were calling the exact piece of code as you gave above, with the declare and set in it?

    Gail, believe it or not, that additional comment is required in the SAP interface.

    A comment is required???? What kind of messed up program need specific comments to work?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 8, 2013 at 10:27 am

    #1574926

    GilaMonster (1/8/2013)

    Brandie Tarvin (1/8/2013)

    GilaMonster (1/8/2013)

    I thought you said you were calling the exact piece of code as you gave above, with the declare and set in it?

    Gail, believe it or not, that additional comment is required in the SAP interface.

    A comment is required???? What kind of messed up program need specific comments to work?

    In SAP, the comment actually defines the parameter for SAP while doing nothing for SQL. Like I said, I only know a smidgen about this, so I couldn't tell you why this works.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply