Occurs after a table is removed from database and deleted from disk by the DROP TABLE command. There are two versions of the syntax.
PROCEDURE dbc_AfterDropTable(cTableName, lRecycle)
PROCEDURE dbc_AfterDropTable LPARAMETERS cTableName, lRecycle
- Specifies the table removed from the current database and deleted from disk.
- Specifies whether the table was placed in the Windows Recycle Bin rather than immediately deleted from the disk.
You can use the dbc_AfterDropTable event to verify an appropriate value for cTableName, use those parameters in a procedure to track, or manage access to the database after a table is removed from the database and from the disk.
If you delete a table by using DELETE FILE or the operating system, no event occurs.
* Reports to the screen the event name, where it is called from, and * the parameter values passed to it. PROCEDURE dbc_AfterDropTable ; (cTableName, ; lRecycle) ? '>> ' + PROGRAM() ?? ' in ' + SUBSTR(SYS(16),RAT('\',SYS(16))+1) ? ' cTableName = ' + TRANSFORM(cTableName) + ' - ' ; + TYPE('cTableName ') ? ' lRecycle = ' + TRANSFORM(lRecycle) + ' - ' ; + TYPE('lRecycle')+' /end/ ' ENDPROC