Need To Update a Field On the Onafterget record tri of form

Prem
Prem Member Posts: 34
edited 2004-11-23 in NAV/Navision Classic Client
Hi All

I would like to disable a record when it is viewed or active in another users screen.

How can i acheive this...?

Cheers

Prem

Comments

  • SteveO
    SteveO Member Posts: 164
    What do you mean disable a record? Make it uneditable?

    You don't really need to worry about this as Navision Proprietary database is built around optimistic concurrency. This means that the user who changes the record first is guarenteed that their change will be the one that takes effect. Any other users who were viewing the same record at the same time and try to change it will receive an error stating that the record was changed after it was retrieved from the database.

    SQL also has it's own build-in mechanisms for dealing with this situation but my knowledge of SQL is very sketchy.
    The Application Designer's guide tells you everything you need to know about table locking for both versions of Navision.

    Hope this sort of answers your question :)
    This isn't a signature, I type this at the bottom of every message

Categories