PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → How could I know if a record is currently being used?
How could I know if a record is currently being used?
Débuté par Jenny, 10 oct. 2008 01:51 - 2 réponses
#1
Posté le 10 octobre 2008 - 01:51
We want to do something like: If one user opens a customer order, another user on invoice module cannot make an invoice from this customer order. We don't want to lock this record. Other user still need to modify this order and its related data files even one user already open this order.
Thank you in advance.
#2
Posté le 10 octobre 2008 - 09:38
Hello Jenny...

Without blocking the record, you can either have a flag field in the
file (User ID+dateTime), or a specific usage table.

In both case, you will have to write who is using what and when (the
when part is important in case of uncontrolled exit of the
application)... The when part should be updated every x minutes (you
choose), this way somebody trying to access a record could force it's
usage if the original app quit refreshing the usage

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


Jenny wrote:
We want to do something like: If one user opens a customer order, another user on invoice module cannot make an invoice from this customer order. We don't want to lock this record. Other user still need to modify this order and its related data files even one user already open this order.
Thank you in advance.
#3
Posté le 10 octobre 2008 - 17:05
Thank you
→ Revenir à WINDEV 2024