# record in use not blocked for other clients

**URL:** <https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798>\
**Category:** Classic Servoy\
**Created:** [September 2, 2010, 9:58am UTC](https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798 "2010-09-02T09:58:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [September 2, 2010, 9:58am UTC](https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798/1 "2010-09-02T09:58:58Z")

</div>

The problem is that other clients can edit a record it is in use by a user in smart client The record isn’t blocked for the other clients!  
How can I fix this?

Servoy 5.2.0  
PostgreSQL 8.4.4

Thomas

---

<div class="post-metadata">

**Author:** ![victor.rojo](https://avatars.discourse-cdn.com/v4/letter/v/57b2e6/32.png) [@victor.rojo](https://forum.servoy.com/u/victor.rojo)\
**Post date:** [September 2, 2010, 10:54am UTC](https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798/2 "2010-09-02T10:54:21Z")

</div>

Hi,

Are you using databaseManager.acquireLock?

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [September 2, 2010, 11:07am UTC](https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798/3 "2010-09-02T11:07:28Z")

</div>

Hi Victor,

I don’t use databaseManager.aquireLock! Should I do this?

I’m using databaseManager.setAutosave(true/false).

Regards,  
Thomas

---

<div class="post-metadata">

**Author:** ![victor.rojo](https://avatars.discourse-cdn.com/v4/letter/v/57b2e6/32.png) [@victor.rojo](https://forum.servoy.com/u/victor.rojo)\
**Post date:** [September 2, 2010, 11:20am UTC](https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798/4 "2010-09-02T11:20:18Z")

</div>

Yes, I think that if you want to block the other users you should use it. Before edit the record try to add a lock to the record,if the acquireLock returns false the record already has a lock (another user is editing it).

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [September 2, 2010, 11:34am UTC](https://forum.servoy.com/t/record-in-use-not-blocked-for-other-clients/12798/5 "2010-09-02T11:34:12Z")

</div>

Ok, thank you! I will try this.

Regards,  
Thomas
