dbc_BeforeDropView Event

Occurs before a View is removed from the current database.

PROCEDURE dbc_BeforeDropView(cViewName) 

-or-

PROCEDURE dbc_BeforeDropView
LPARAMETERS cViewName

Parameters

• cViewName
  Specifies the name of the view to be deleted from the current database.

Remarks

DROP VIEW is almost identical to DELETE VIEW; DROP VIEW is the ANSI SQL standard syntax for deleting a SQL view. Both commands remove a view definition from the active database, but the syntax is slightly different.

You can use the dbc_BeforeDropView event to track attempted access to the database before a view is removed from the database.

Return .F. from this procedure to prevent the view from being dropped.

Example

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

See Also

Enable or Disable DBC Events | dbc_AfterDropView Event