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.