NEW4.00.01 · Released 20 March 2023
NEWfinPOWER Connect
Released in
4.00.01
20 March 2023
- Opened20 Feb
- Closed20 Feb
- Released20 Mar
Article 19968
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.