BeforeModifyView, AfterModifyView
These database events fire when a view is modified in the View Designer. Usage | PROCEDURE DBC_BeforeModifyView( cViewName ) PROCEDURE DBC_AfterModifyView( cViewName, lChanged ) |
Parameter | Value | Meaning |
cViewName | Character | The name of the view being modified. |
lChanged | Logical | Indicates whether the view was changed. |
Example | * This goes in the stored procedures of a database. PROCEDURE DBC_BeforeModifyView(cViewName) WAIT WINDOW PROGRAM() + CHR(13) + ; 'cViewName: ' + cViewName PROCEDURE DBC_AfterModifyView(cViewName, lChanged) WAIT WINDOW PROGRAM() + CHR(13) + ; 'cViewName: ' + cViewName + CHR(13) + ; 'lChanged: ' + TRANSFORM(lChanged) * End of stored procedures. * Create a view, and then modify it. OPEN DATABASE TestData DBSETPROP(DBC(), 'Database', 'DBCEvents', .T.) && Turn on events CREATE SQL VIEW TestView AS SELECT * FROM Customer MODIFY VIEW TestView |
See Also | BeforeCreateView, BeforeDropView, Create SQL View, Database Events, Modify View |
View Updates
Copyright © 2002 by Tamar E. Granor, Ted Roche, Doug Hennig, and Della Martin. All Rights Reserved.