Loading...

Is there a way using qlist form to use return value from sql to do a custom message?

Is there a way using qlist form to use return value from sql to do a custom message?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #4430
      Anonymous
      Anonymous
      Participant

      Hello Community,

      QWP’s version = 5.7Build 2012.3.15SharePoint version = 2007

      Interesting configuration question here:

      Scenario:

      • 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).

      Idea:

      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.

      Question:

      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—

      Thank you,

      Richard

    • #5309
      Anonymous
      Anonymous
      Participant

      In the stored procedure you add code to raise an error and catch that error in the SIListForm and display the message.

Viewing 1 reply thread

You must be logged in to reply to this topic.