- This topic is empty.
12/11/2012 at 8:50 am #4430
QWP’s version = 5.7Build 2012.3.15SharePoint version = 2007
Interesting configuration question here:
- Customer is using a stored procedure with a siQlistform that is set to edit form and he is passing an ID parameter to the stored procedure to extract the data to edit…
- He has a trigger on the insert of a new row to use the send dbmail to notify the end user of when a high priority ticket has been entered…
- That notification has a link with it that has the url and the ID in it so that all the user has to do is click it and it will pull up the ticket…
BUT…sometimes the ticket may be deleted by the end user. They can delete their own tickets….So if that (ticket delete) happens he has already sent the link with the ID and now when they (the users) click it the form comes up blank because the ID is not found in the database. (Customer knows this is not the most convenient way but this is what is existing currently).
So what the customer wants to do is validate the ID in the stored procedure and change the return code from the normal of (0) to something else if the ID is not found in the database and use that in the form to notify the user that it has been deleted.
Is there a way using qlist form to use return value from sql to do a custom message?
—Customer has been given this forum link and will be monitoring with any further required specifics—
12/11/2012 at 8:50 am #5309
In the stored procedure you add code to raise an error and catch that error in the SIListForm and display the message.
You must be logged in to reply to this topic.