• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 58 views
  • Users 0 members are here
Related

Dynamic list in stored procedure

Former Member
Former Member $organization

Hi

Is it possible to use a dynamic list in a stored SQL procedure? I would like to create logins on a nightly basis for patrons who fit specific criteria but when I try this in our test system, the list is not updating every time the procedure runs.

Thanks
Jess Levy

SFMOMA
jlevy@sfmoma.org

Parents
  • $organization

    Hi Jess,

    I believe you would need to call [RP_GENERATE_LIST] in your stored procedure in order to generate the contents of the list again.

     

     

    Tanya Hoffmann

    Kennedy Center

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jess Levy
    Sent: Tuesday, March 29, 2016 1:58 PM
    To: Hoffmann, Tanya
    Subject: [Tessitura Technical Forum] Dynamic list in stored procedure

     

    Hi

    Is it possible to use a dynamic list in a stored SQL procedure? I would like to create logins on a nightly basis for patrons who fit specific criteria but when I try this in our test system, the list is not updating every time the procedure runs.

    Thanks
    Jess Levy

    SFMOMA
    jlevy@sfmoma.org




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Reply
  • $organization

    Hi Jess,

    I believe you would need to call [RP_GENERATE_LIST] in your stored procedure in order to generate the contents of the list again.

     

     

    Tanya Hoffmann

    Kennedy Center

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jess Levy
    Sent: Tuesday, March 29, 2016 1:58 PM
    To: Hoffmann, Tanya
    Subject: [Tessitura Technical Forum] Dynamic list in stored procedure

     

    Hi

    Is it possible to use a dynamic list in a stored SQL procedure? I would like to create logins on a nightly basis for patrons who fit specific criteria but when I try this in our test system, the list is not updating every time the procedure runs.

    Thanks
    Jess Levy

    SFMOMA
    jlevy@sfmoma.org




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!



    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Children
No Data