Skip to Content
author's profile photo Former Member
Former Member

Handling Users logged in concurrently and trying to give a pop up message

I am using Model View Controllers for one BSP Application. In DO_HANDLE_EVENT i am trying to insert some rows in a Custom table.

If so many users are trying to insert into Custom table concurrently, i want them to restrict and give a message saying this is being modified by some other user.

Can any body tell me how to handle the message and also how do i know if any other one is trying to insert the row into the Custom table.

Thanks in advance,

Sanjay Singh

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 08, 2006 at 12:04 PM

    Hi,

    Welcome to SDN!

    You should put a lock on your custom table. This way, you can easily manage single access for updates.

    Have a look at FM : <b>ENQUEUE_E_TABLE</b> and <b>DEQUEUE_E_TABLE</b>.

    Regarding the popup message, I really like the PTHMLB messageBar control (together with the dataTip, it's a must !) 😊

    Best regards,

    Guillaume

    Message was edited by: Guillaume Garcia

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      In the lyout, you specify a PHTMLB message bar with a condition that a page attribute (for instance w_error_msg) must be not initial.

      Then, in the OnInputProcessing event, you fill in the w_error_msg attribute.

      This gives something like :

      <b>Layout</b>

      <% IF w_error_msg IS NOT INITIAL. %>
           <%-- Display of error message --%>
           <phtmlb:messageBar id                = "msgBar"
                             type               = "ERROR"
                             text               = "<%= w_error_msg %>"
                             rulerDisplay       = "BOTTOM"
      <% ENDIF. %>

      <b>OnInputProcessing</b>

      * test to set variable is_table_locked
      IF is_table_locked.
        w_error_msg = 'Table is currently locked.'.
      ENDIF.

      Hope it helps.

      Best regards,

      Guillaume

      PS: Please close the thread if your question has been correctly answered and reward points for helpful answers.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.