dbc_AfterDropTable Event
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
Parameters
cTableName
Specifies the table removed from the current database and deleted from disk.lRecycle
Specifies whether the table was placed in the Windows Recycle Bin rather than immediately deleted from the disk.
Remarks
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.
Example
* 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
See Also
Tasks
How to: Enable or Disable DBC Events