Article Details
Id:19968
Product:finPOWER Connect
Type:NEW
Version:4.00.01
Opened:20/02/2023
Closed:20/02/2023
Released:20/03/2023
Job: J030477

ISDeleteQueryBuilder; Added TopLimit for SQL Server

The ISDeleteQueryBuilder object now supports a TopLimit for the SQL Server database provider. This allows you to specify, for example, only 100 records will be deleted.

Note, the database provider now also includes a property to indicate whether the database engine supports a top limit.

finBL.Database.CurrentProviderUtilities.SupportsDeleteTopLimit

NOTE: the TopLimit will delete random rows within the query because the rows are not arranged in any order - as the DELETE query does not support ORDER BY.