Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Red face Unanswered: Check Data concurrent

    hi all

    I have a form contains a button and a grid based on table x ( no, value)
    when I press the button I read data from the current record and make process depend on this data.

    the problem is :
    If I open the form and query for certain row (no=1 and value=150), then I open another session and query the same row (no=1 and value=150) and change the value to 800 and save, in the first session the value 150 still appear, if I press the button the process will read the value 150.

    How I can know if the is changed or not ?

    for this example its easy to use GE_ITEM_PROPERTY(...., DATABASE_VALUE)
    but if I have alot of field in the form its hard to check all of them.

    thanx in advance

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    One option is to lock the table, such as
    Code:
    lock table x in exclusive mode nowait;
    Nobody will be able to modify it, until you commit (or rollback) changes you made.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    In the data block property, set the "locking mode property" to immediate.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •