Home page  
Help >
DDL MODE MEMOLOCK
Version 7.11
MODE MEMOLOCK

MODE MEMOLOCK [ON/OFF]

This controls how we handle simultaneous access/update for Memo fields.
ON is the default. ON is generally what you want to use in a Local Area Network, but maybe not after you read this. Even if MODE MEMOLOCK is ON, all Engine users (generally coming through the Internet) will act as if it is OFF for them.

ON: Multiple users can access the same Memo field at the same time. But the first one who starts to change it gets a change lock on it such that the second and subsequent people who start to change it get notified that some- one else is changing it and they should try again later.

OFF: Multiple users can access and change the same Memo field at the same time. The first user to save changes updates the Memo field. Each sub- sequent save creates a new generation of that Memo field such that when they have all saved, the Memo field will have multiple versions. At some point later, an arbitrator can access all generations of the Memo field (G option on the UPDATE command) and use copy and paste to combine the multiple versions into one, then discard the extra versions.

When the UPDATE/G is used you will know if the Memo field has more than one version because the control to open it will show red. Then a shift click when you open it will show all generations.

There is a special query you can do to find all the Memo fields that have more than one generation:

FIND A tname WHERE memo-field-name > 1

Copyright © 2019 , WhamTech, Inc.  All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Names may be trademarks of their respective owners.