Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
How to determine number of records deleted using SQL? |
Thu, May 7 2015 2:43 PM | Permanent Link |
Robert D. Smith | I have an SQL statement to a table that deletes records based on a timestamp.
I've tried using the BeforeDelete and AfterDelete events to increment a counter variable, but it never hits these events. However, the SQL executes with no issue. How can I determine the number of records deleted (or the records that will be deleted)? I know I can probably use a select and get a recordcount beforehand, but was just wondering if there's a way I wouldn't have to execute 2 statements, as well as provide a progress bar to indicate where it is in the delete process. Sorry if this is a stupid question - I've always used tables in the past, but need to use SQL due to the timestamp being variable. |
Thu, May 7 2015 3:03 PM | Permanent Link |
Robert D. Smith | I found it! Please disregard...
|
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |