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.