I haven't been experienced with locks.
I have 2 scenarios:
1. We are using Jaguar 3.0 and HTML DW developed by PowerBuilder 7.0 for
a web-based application. The user updates a DW (a DW which allowing
updates, Key and updatable Columns) and another user is able to open the
same DW and update the same dat. How i can prevent the second user from
opening the DW or how i can lock his attempt to change the data which at
the same time are changed by the first user?
2. In PowerDynamo we are using embedded SQL select commands to show
some data form the database in an HTML form. The user may change the
data and clicking on a button Update, he performs an UPDATE query. A
second user may select the data with the embedded SQL command and change
them concurrently. Depending of who of the 2 users will press the button
update last (perform the UPDATE command last) only his changes will be
stored in the database. How i can prevent the second user from Selecting
the data when those data are changing by the first user in the HTML
Now my database seems to be "single user" .
Any help is appreciated !!!!
Download VCard p.panagos.vcf