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