Home » Other » Client Tools » Re: Update problem
Re: Update problem [message #38693] Mon, 06 May 2002 21:30
Varkey
Messages: 1
Registered: May 2002
Junior Member
That does not solve the problem. You cannot lock the rows till the user (Ineternet User) completes his modifications to a record from his browser. The web application would give the requested the rows to the user, then disconnect the DB connection. When the user resubmit his modifications, the webserver would seek the original row and update it. But in the meantime if another user updated the record, the web application would identify and alert the user about it. You need a column like timestamp as in SQL Server for this. (Timestamp i SQL Server is a datatype which cannot be modified by the user) The web application can check the Timestamp of the records to be updated for any difference.
Previous Topic: How to use IN parameters with in the begin statement..
Next Topic: Imp: View a trigger history
Goto Forum:
  


Current Time: Fri Mar 29 06:17:55 CDT 2024