Re: Avoiding 'Record updated by other user' error
Date: 1998/01/22
Message-ID: <19980122180400.NAA03395_at_ladder02.news.aol.com>#1/1
>Does anyone know a simple way to avoid the error 'Record updated by
>another user. Requery to see changes' without requerying manually?
>
>Here is our situation:
>
>Inside a Forms4.5 form there is a button which changes a field of the
>current record. This change is noticed by a server-side pro*c daemon
>that, after some processing, changes this field again. The update made by
>the daemon is notified to the form via a pipe. So when the daemon
>finishes with the record, control is returned to the Form. After this we
>try to update from our Form one of the fields of this record but we get
>the error message and are not allowed to do so until we requery.
>
>What we are looking for is some way of avoiding this, preferably without
>having to requery the database.
>
>
Hi
You can write a procedure to overwrite the record with the current database values. Query using ROWID and this will be very fast. Then set the record status to QUERY-STATUS.
John
John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103
FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com
e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/
The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.
Received on Thu Jan 22 1998 - 00:00:00 CET