js editor
Web development
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
| В |  Copy Code |
|---|---|
* 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 | |