.NET Customisation
User Guide
.NET Customisation
:
Database Interface
:
DBs, MDBs and Projects
: DB Functionality
DB Functionality
When an MDB is opened, a DB class instance is created for each opened DB.
The functionality offered by this class falls into the following categories:
•
Query the properties of the DB, for example: number, MULTIWRITE or not
•
Returning the world element for that DB
•
Session information, for example: when was the session written and by whom. There is a DbSession object that holds details on a database session.
•
Return the DbElement in the system DB that represents this DB. This DbElement can then be used to query system attributes and additional pseudo attributes. The additional pseudo attributes available on the DbElement representing the DB are described below:
Attribute Name
Data Type
Qualifier
Description
ACCEDB
string
DB access
CLAIM
String
Implicit or explicit claims
CLCCNT
int
Claim list changes count
CSESS
String
int
Comment entered for specified session
DACC
String
Database access
DBLC
DbElement[]
List of LOCs belonging to a DB
DCLA
String
Database claim mode
DSESS
String
int
Date of specified session
EXPIRY
String
Protected DB Expiry date
EXTALS
DbElement[]
Extract ancestors
EXTCLS
DbElement[]
Extract children
EXTDES
DbElement[]
Extract descendants
EXTFAM
DbElement[]
Extract family
FILENAME
String
DB filename
FOREIGN
string
Originating project
HCCNT
int
Header/Extract list changes count
ISDBFR
bool
True if database is foreign
ISDRDB
Bool
True if database has drawings
ISWORK
bool
True if a working extract
LINKSN
int
Linked session on parent extract
LPROT
bool
Protected DB Flag
MDBCLS
DbElement[]
List of MDBs in which DB is current
MDBLS
DbElement[]
List of MDBs to which DB belongs
NACCNT
int
Non-additive changes count
NAMEDB
string
DB name
NXTDBN
int
Next DB number
NXTEXN
int
Next DB extract number
NXTFDB
int
Next DB file and DB number
NXTFLN
int
Next DB file number
PSESS
int
int
Previous session number
SIZEDB
int
Size of DB
STPDBS
DbElement[]
Stamps containing db
STPSES
Int[]
Sessions used in at least one stamp
STYPDB
string
DB sub type
TYPEDB
string
DB type
USESS
string
int
User creating session
In addition for any DbElement in any DB, the following pseudo attributes provide information on the current DB:
Attribute Name
Data Type
Qualifier
Description
DBAC
String
DB Access, MULTIWRITE or UPDATE
DBCL
String
DB Claim
DBCNTL
Bool
True if element is in a control DB
DBEXNO
int
DB Extract Number
DBFI
String
DB filename
DBFN
int
DB file number
DBNA
String
DB name
DBNU
int
DB Number
DBREF
DbElement
Reference of DB element
DBTY
String
DB type (DESI, CATA etc)
DBVAR
Bool
True if element is in a variant DB
DBWRITE
Bool
True if element is in a writable DB
WDBNA
STRING
Working DB name
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.