|
<< Click to Display Table of Contents >> Object properties |
  
|
|
<< Click to Display Table of Contents >> Object properties |
|
Each Borland Database Engine (BDE) object is defined by its own set of properties as described in the following table.
| Note: | Not all drivers support all properties. Also, some properties are valid only at certain times. For example, stmtLIVENESS is valid only before DbiQPrepare. |
Properties |
System |
Session |
Database |
Driver |
Cursor |
Statement |
sysMAXPROPS |
X |
X |
X |
X |
X |
X |
sysLOWMEMUSAGE |
X |
X |
X |
X |
X |
X |
sesMAXPROPS |
|
X |
X |
|
X |
X |
sesSESSIONNAME |
|
X |
X |
|
X |
X |
sesNETFILE |
|
X |
X |
|
X |
X |
sesCFGNAME |
|
X |
X |
|
X |
X |
sesCFGUPDATE |
|
X |
X |
|
X |
X |
sesCFGMODE2 |
|
X |
X |
|
X |
X |
dbBATCHCOUNT |
|
|
X |
|
|
|
dbBLOBCOUNT |
|
|
X |
|
|
|
dbBLOBSIZE |
|
|
X |
|
|
|
dbMAXPROPS |
|
|
X |
|
X |
X |
dbDATABASENAME |
|
|
X |
|
X |
X |
dbDATABASETYPE |
|
|
X |
|
X |
X |
dbASYNCSUPPORT |
|
|
X |
|
|
|
dbPROCEDURES |
|
|
X |
|
|
|
dbDEFAULTTXNISO |
|
|
X |
|
|
|
dbNATIVEHNDL |
|
|
X |
|
|
|
dbNATIVEPASSTHRUHNDL |
|
|
|
X |
|
|
dbUSESCHEMAFILE |
|
|
X |
|
|
|
dbSERVERVERSION |
|
|
X |
X |
|
|
dbTRACEMODE |
|
|
|
|
|
|
drvMAXPROPS |
|
|
X |
X |
X |
|
drvDRIVERTYPE |
|
|
|
X |
X |
|
drvDRIVERVERSION |
|
|
|
X |
X |
|
cfgREFRESH |
X |
X |
|
|
|
|
curGETEXTENDEDINFO |
|
|
|
|
X |
|
curMAXPROPS |
|
|
|
|
X |
|
curMAXROWS |
|
|
X |
X |
X |
|
curTABLENAME |
|
|
|
|
X |
|
curTABLETYPE |
|
|
|
|
X |
|
curTABLELEVEL |
|
|
|
|
X |
|
curFILENAME |
|
|
|
|
X |
|
curXLTMODE |
|
|
|
|
X |
|
curSEQREADON |
|
|
|
|
X |
|
curONEPASSON |
|
|
|
|
X |
|
curUPDATETS |
|
|
|
|
X |
|
curSOFTDELETEON |
|
|
|
|
X |
|
curLANGDRVNAME |
|
|
|
|
X |
|
curPDXMAXPROPS |
|
|
|
|
X |
|
curDBMAXPROPS |
|
|
|
|
X |
|
curINEXACTON |
|
|
|
|
X |
|
curNATIVEHNDL |
|
|
|
|
X |
|
curUPDLOCKMODE |
|
|
|
|
X |
|
stmtMAXPROPS |
|
|
|
|
|
X |
stmtPARAMCOUNT |
|
|
|
|
|
X |
stmtUNIDIRECTIONAL |
|
|
|
|
|
X |
stmtANSTYPE |
|
|
|
|
|
X |
stmtLIVENESS |
|
|
|
|
|
X |
stmtQRYMODE |
|
|
|
|
|
X |
stmtBLANKS |
|
|
|
|
|
X |
stmtDATEFORMAT |
|
|
|
|
|
X |
stmtNUMBERFORMAT |
|
|
|
|
|
X |
stmtAUXTBLS |
|
|
|
|
|
X |
stmtTBLVECTOR |
|
|
|
|
|
X |
stmtALLPROPS |
|
|
|
|
|
X |
stmtALLPROPSSIZE |
|
|
|
|
|
X |
stmtANSNAME |
|
|
|
|
|
X |
stmtNATIVEHNDL |
|
|
|
|
|
X |
stmtCURSORNAME |
|
|
|
|
|
X |
stmtROWCOUNT |
|
|
|
|
|
X |
stmtCONSTRAINED |
|
|
|
|
|
X |
stmtFIELDDESCS |
|
|
|
|
|
X |
stmtCURPROPS |
|
|
|
|
|
X |
Descriptions
| sesCFGUPDATE | When set to ON, the session receives a copy of any alias or driver additions that are applied to other sessions. Set to OFF to disable this behavior. |
| sesCFGNAME | Read only property that returns the name of the configuration file in use by the session. |
| dbBLOBCOUNT | Read only property that returns the current setting of BLOBS TO CACHE. |
| dbBLOBSIZE | Read only property that returns the current setting of BLOB SIZE. |
| CfgREFRESH | Specifies whether the BDE retrieves virtual ODBC information each time it is needed (TRUE) or only at the start of the BDE session (FALSE), which improves performance. |