Tech Tip: Quickly find which tables are not being logged to the journal file
PRODUCT: 4D | VERSION: 16 | PLATFORM: Mac & Win
Published On: January 11, 2018
The following snippet of code can be used to quickly get a list of tables that are not being logged to the Journal file:
C_TEXT($msg;$tableList) ARRAY TEXT($atTables;0) // get array of tables not being logged to the journal file Begin SQL SELECT TABLE_NAME from _USER_TABLES where LOGGED = false into :$atTables; End SQL // format the array into a comma seperated list $tableList:=JSON Stringify array($atTables) $tableList:=Replace string($tableList;Char(Double quote);"") $tableList:=Replace string($tableList;",";"], [") // prepare a message and alert the developer $msg:="The following tables have the \"Include in Log File\" property disabled:\r\r" $msg:=$msg+$tableList ALERT($msg) |
When executed, an ALERT dialog will be displayed with a list of tables that are not being logged:
See Also: