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.
ThanksJess Levy
SFMOMAjlevy@sfmoma.org
Here's what got stripped out the first time around:
You need to insert code into your procedure to regenerate a dynamic list. Here’s what I cribbed from a report procedure and stick near the top of local procedures that run using a list. This assumes that you have a parameter called @list_no:
/**regenerate list if necessary**/
declare @dynamic char(1)
set @dynamic = (select recalc_status from t_list where list_no = @list_no)
if @dynamic = 'S'
goto static_list
exec rp_generate_list
@list_no = @list_no,
@display_names = 'N'
--
static_list:
/**end**/
Thanks for the quick responses!BestJess
_____________________________________________
Lucie Spieler Florida Grand Opera
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
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!