dbc_AfterRemoveTable Event

Occurs after table removal is complete. There are two versions of the syntax.

PROCEDURE dbc_AfterRemoveTable(cTableName, lDelete, lRecycle) 

PROCEDURE dbc_AfterRemoveTable
LPARAMETERS cTableName, lDelete, lRecycle

Parameters

  • cTableName
    Specifies the name of the table that was removed from the database.
  • lDelete
    Specifies whether the table was deleted instead of being converted to a free table.
  • lRecycle
    Specifies whether the table was placed in the Windows Recycle Bin rather than immediately deleted from the disk. Some data, such as the table properties available only in tables contained in a database, is lost even if the table is only recycled rather than removed and deleted.

Remarks

You can use the dbc_AfterRemoveTable event to track access to the database after a table is removed from the database and from the disk.

Example

* Reports to the screen Event name, where it is called from and ;
* the parameters passed.
PROCEDURE dbc_AfterRemoveTable ;
         (cTableName, ;
          lDelete, ;
          lRecycle)
? '>>   ' + PROGRAM()
?? ' in ' + SUBSTR(SYS(16),RAT('\',SYS(16))+1)
? '     cTableName = ' + TRANSFORM(cTableName) + ' - ' ;
                   + TYPE('cTableName ')
? '     lDelete    = ' + TRANSFORM(lDelete)    + ' - ' ;
                   + TYPE('lDelete')
? '     lRecycle   = ' + TRANSFORM(lRecycle)   + ' - ' ;
                   + TYPE('lRecycle')+' /end/ '
ENDPROC

See Also

Tasks

How to: Enable or Disable DBC Events

Reference

dbc_BeforeRemoveTable Event

Other Resources

Events (Visual FoxPro)
Language Reference (Visual FoxPro)