Any SAPs out there?
+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Posts 11 to 12 of 12
  1. #11

    TPAFKAk2p2

    mudskipper's Avatar
    Join Date
    Sep 2009
    Location
    Null island
    Posts
    24,762
    Thanks (Given)
    807
    Thanks (Received)
    1364
    Likes (Given)
    6235
    Likes (Received)
    4883

    Default

    The idea of this is that we don't need to make any changes to the datasource databases, so no creating a stored procedure.

    Having said that, they are happy for us to do so.

    But I don't want to change the code to call a stored procedure if I can help it - I'm trying to keep it as generic as possible.

    So we'd need to call the SP from the sql command, so would still have the issue of passing paramters to the sql so that it could pass them to the SP.

    If I do need to change the code, I will, but we've got this solution working nicely for about a dozen customers already, so if I can avoid specific code for specific customers I'd prefer to.

    I'm pretty sure it's just a syntax thing - just frustrating not to be able to sit and play with it without the pain of a webex with everyone watching!

    I'll try NAT's download and see if I can get that working.

  2. #12

    TPAFKAk2p2

    mudskipper's Avatar
    Join Date
    Sep 2009
    Location
    Null island
    Posts
    24,762
    Thanks (Given)
    807
    Thanks (Received)
    1364
    Likes (Given)
    6235
    Likes (Received)
    4883

    Default

    In case anyone cares, we got round it by creating a stored procedure whose signature took all the parameters in the order that the odbc command is passing them, then changed the sql command to just call the sp (so no code change). Not perfect, but it works and I get paid

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.