Difference between revisions of "DBC OPENDATA"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 40: | Line 40: | ||
|} | |} | ||
| − | Programs associated with database events should reside in the database's directory. | + | Programs associated with database events should reside in the database's directory. These can be created and modified from the Events tab in the Data Workspace when a database is open. |
==Example== | ==Example== | ||
| Line 46: | Line 46: | ||
procedure dbc_opendata | procedure dbc_opendata | ||
lparameters cName, lExcl, lRo, lValidate | lparameters cName, lExcl, lRo, lValidate | ||
| − | + | // ... | |
| − | return | + | return .T. |
</code> | </code> | ||
Revision as of 05:50, 17 October 2016
Contents
Purpose
Database events are triggered by certain database operations
Syntax
PROCEDURE dbc_OpenData(<expC>,<expL1>,<expL2>,<expL3>)
// Commands
ENDPROC | RETURN [<expL4>]
or
PROCEDURE dbc_OpenData
LPARAMETERS [<expC>,<expL>,<expL2>,<expL3>]
// Commands
ENDPROC | RETURN [<expL4>]
See Also
ADATABASES(), ALTER TABLE, ADD TABLE, ALTER INDEX, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, CREATE DATABASE, CREATE TABLE, CREATE INDEX, CREATE VIEW, DATABASE(), Database Events, DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), LIST DATABASE, LIST INDEXES, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET EXCLUSIVE, USE
Description
The DBC_OPENDATA database event is triggered when a database is opened. The associated code is run before the database is actually opened. Databases are opened using the OPEN DATABASE <database-name> command.
| Event | Description |
|---|---|
| <expC> | The database name |
| <expL1> | Specifies whether the database is being opened exclusively, .T. or shared, .F. |
| <expL2> | Specifies whether the NOPUDATE keyword was included on the OPEN DATABASE command, .T. or not, .F. |
| <expL3> | Specifies whether the VALIDATE keyword was included on the OPEN DATABASE command, .T. or not, .F. |
| <expL4> | If the dbc_opendata procedure returns .F., the database is not opened, if .T., the open operation continues |
Programs associated with database events should reside in the database's directory. These can be created and modified from the Events tab in the Data Workspace when a database is open.
Example
procedure dbc_opendata lparameters cName, lExcl, lRo, lValidate // ... return .T.
