Article Details

Id:	20817
Product:	finPOWER Connect
Type:	NEW
Version:	4.00.04
Opened:	09/10/2023
Closed:	12/10/2023
Released:	05/12/2023
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