Locking time

John3
John3 Member Posts: 16
edited 2009-10-01 in Navision Financials
I have a 2.60B Database.

Could somebody tell how I could increase the locking time ?

Thanks for sharing !

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    What do you mean with "locking time"?
    PS are you on SQL or native?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • David_Singleton
    David_Singleton Member Posts: 5,479
    John3 wrote:
    I have a 2.60B Database.

    Could somebody tell how I could increase the locking time ?

    Thanks for sharing !

    Get users to open dialogs and not hit OK. Also you could post bigger inovices :evil:

    Sorry couldn't resist. 8)
    David Singleton
  • John3
    John3 Member Posts: 16
    kriki wrote:
    What do you mean with "locking time"?
    PS are you on SQL or native?

    The time that navision waits when a table is locked.

    In stead of inmediatly an error that the system wait until the locking time is passed.

    It's a native database
  • David_Singleton
    David_Singleton Member Posts: 5,479
    John3 wrote:
    kriki wrote:
    What do you mean with "locking time"?
    PS are you on SQL or native?

    The time that navision waits when a table is locked.

    In stead of inmediatly an error that the system wait until the locking time is passed.

    It's a native database

    In native there really is nothign like this. In code the developer can chose to give an error message or wait till the locked table is committed.
    David Singleton
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    You can implement this feature by migrating to SQL.

    O:)
    Marije Brummel | Freelance Business Central Specialist
  • John3
    John3 Member Posts: 16
    David Singleton wrote:
    John3 wrote:
    kriki wrote:
    What do you mean with "locking time"?
    PS are you on SQL or native?

    The time that navision waits when a table is locked.

    In stead of inmediatly an error that the system wait until the locking time is passed.

    It's a native database

    In native there really is nothign like this. In code the developer can chose to give an error message or wait till the locked table is committed.

    Can you give me an example of the code, thanks very much
  • kriki
    kriki Member, Moderator Posts: 9,121
    Check the on-line help of the LOCKTABLE-command. In it is explained what to do.
    But my advice is to leave it standard.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • John3
    John3 Member Posts: 16
    kriki wrote:
    Check the on-line help of the LOCKTABLE-command. In it is explained what to do.
    But my advice is to leave it standard.

    I have used the code record.locktable(true,false) so the system must wait until the table is unlocked.

    But instead I get immediatly an error.

Categories