JavaScript Editor js editor     Web development 

Main Page

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.


В 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, ;
? '>>   ' + PROGRAM()
?? ' in ' + SUBSTR(SYS(16),RAT('\',SYS(16))+1)
? '     cTableName = ' + TRANSFORM(cTableName) + ' - ' ;
                   + TYPE('cTableName ')
? '     lRecycle   = ' + TRANSFORM(lRecycle)   + ' - ' ;
                   + TYPE('lRecycle')+' /end/ '

See Also

JavaScript Editor js editor     Web development