DBC AFTEROPENTABLE

From Lianjapedia
Jump to: navigation, search

Purpose

Database events are triggered by certain database operations

See Also

ADATABASES(), ALTER TABLE, ADD TABLE, ALTER INDEX, BASE64_DECODE(), BASE64_ENCODE(), 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, USERLOG()

Description

The DBC_AFTEROPENTABLE database event is triggered by an open table operation after opening the table.

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.

The following parameters are passed to the dbc_afteropentable program:

Parameter Description
<cDatabase> The database name
<cTable> The table name

Example

//
// Database: dbcdoc
// Event: dbc_afteropentable
//
parameters cDatabase, cTable
userlog("====================================")
userlog("After Open Table in "+"dbcdoc database")
userlog("Database: " +cDatabase)
userlog("Table: " +cTable)
if lTesting
  set connstr to 
endif
userlog("End of After Open Table")
userlog("====================================")
return .t.