Tony,
I'm interested in the rollback idea! Jan From: Tony IJntema <[email protected]> To: [email protected] Date: Thu, 22 Apr 2021 20:06:18 +0200 Subject: Re: [RBASE-L] - Suggestions on Using AutoCHK in a Command File Paul, I have implemented more or less the same procedure as Karen describes with a few differences. The differences are: On beforehand I perform some calculations like counting the number of columns in all tables and the total number of rows in the database It looks like this: SET VAR V_SYS_NUM_COLUMNS_ATL BIGINT = 0 SET VAR V_SYS_NUM_ROWS_ATL BIGINT = 0 SET VAR V_TOTAAL BIGINT = 0 -- SELECT SUM(SYS_NUM_COLUMNS) INTO V_SYS_NUM_COLUMNS_ATL INDICATOR V_IND01S FROM SYS_TABLES WHERE SYS_TABLE_TYPE = 'Table' SELECT SUM(SYS_NUM_ROWS) INTO V_SYS_NUM_ROWS_ATL INDICATOR V_IND02S FROM SYS_TABLES WHERE SYS_TABLE_TYPE = 'Table' -- SET VAR V_TOTAAL = (.V_SYS_NUM_COLUMNS_ATL + .V_SYS_NUM_ROWS_ATL) Then I perform a reload with setting error messages on. After the reload I perform the same calculations and compare the outcome with the apriori calculations If there is a difference I rollback the database. Tony Op 22-04-2021 om 15:46 schreef [email protected]: Good morning, I’m running the latest build of R:BASE X.5 Enterprise and I’m trying to incorporate the AutoCHK command to run in a scheduled task every night before doing a “Pack in Place”. Anyone have experience with this? Anyone will to share your code? Thought I’d ask that last one 😊 Thanks, Paul Buckley -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAJ4mzQXf2gpHhGgkNNfb5kTCgAAAEAAAAPzkRWmLe5JOt01PLYI1e4kBAAAAAA%3D%3D%40buckleyandassoc.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/ba810e9a-4c66-3004-f1ff-15bac62592a9%40cio-bv.nl. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/WC20210422181456.09008C%40jjcalibrations.com.
