NEW4.00.04 · Released 5 December 2023
NEWfinPOWER Connect
Released in
4.00.04
5 December 2023
  1. Opened9 Oct
  2. Closed12 Oct
  3. Released5 Dec
Article 20817 Job J032194

Standard Ranges and Task Manager 2 now minimise potential locking issues when using SQL Server databases

The ISSelectQueryBuilder business layer object allows a locking hint to be specified. For non-critical functionality such as counting or listing items in Task Manager folders or, presenting the User with a list of records for a Standard Range (e.g., Clients), this has now been applied as per the following example:

' Create Query
sqb = mDatabase.CreateSelectQueryBuilder()
With sqb
  .Table = "AccountApp"
  .TableHintNoLock = True