/*********************************************************************** * Microsoft Jet * * Microsoft Confidential. Copyright 1991-1993 Microsoft Corporation. * * Component: * * File: jet.h * * File Comments: * * Public header file with JET API definition. * * Revision History: * * [0] 04-Jan-92 richards Added this header * ***********************************************************************/ // // This __JET500 essentially creates two version of this file in this // same file. All the jet500 stuff is in __JET500 macro // #if __JET500 #include "jet500.h" // // End of 500 series jet.h #else // // Original jet.h starts here. i.e jet.h of 200 series db. // #if !defined(_JET_INCLUDED) #define _JET_INCLUDED #ifdef __cplusplus extern "C" { #endif #pragma pack(4) #if defined(_M_ALPHA) /* 0:32 Flat Model (Alpha AXP) */ #define _far #define JET_API __stdcall #define JET_NODSAPI __stdcall #elif defined(M_MRX000) /* 0:32 Flat Model (MIPS Rx000) */ #define _far #define JET_API __stdcall #define JET_NODSAPI __stdcall #else /* 0:32 flat model (Intel 32-bit ) */ #define _far #define JET_API __stdcall /* CONSIDER: Switch to __stdcall */ #define JET_NODSAPI __stdcall /* CONSIDER: Switch to __stdcall */ #endif typedef long JET_ERR; typedef unsigned long JET_INSTANCE; /* Instance Identifier */ typedef unsigned long JET_SESID; /* Session Identifier */ typedef unsigned long JET_TABLEID; /* Table Identifier */ typedef unsigned long JET_COLUMNID; /* Column Identifier */ typedef unsigned long JET_DBID; /* Database Identifier */ typedef unsigned long JET_OBJTYP; /* Object Type */ typedef unsigned long JET_COLTYP; /* Column Type */ typedef unsigned long JET_GRBIT; /* Group of Bits */ typedef unsigned long JET_ACM; /* Access Mask */ typedef unsigned long JET_RNT; /* Repair Notification Type */ typedef unsigned long JET_SNP; /* Status Notification Process */ typedef unsigned long JET_SNT; /* Status Notification Type */ typedef unsigned long JET_SNC; /* Status Notification Code */ typedef double JET_DATESERIAL; /* JET_coltypDateTime format */ #if defined(_M_ALPHA) /* 0:32 Flat Model (Intel 80x86) */ typedef JET_ERR (__stdcall *JET_PFNSTATUS)(JET_SESID sesid, JET_SNP snp, JET_SNT snt, void _far *pv); #elif defined(M_MRX000) /* 0:32 Flat Model (MIPS Rx000) */ typedef JET_ERR (__stdcall *JET_PFNSTATUS)(JET_SESID sesid, JET_SNP snp, JET_SNT snt, void _far *pv); #else /* 0:32 flat model (Alpha AXP ) */ typedef JET_ERR (__stdcall *JET_PFNSTATUS)(JET_SESID sesid, JET_SNP snp, JET_SNT snt, void _far *pv); #endif /* Session information bits */ #define JET_bitCIMCommitted 0x00000001 #define JET_bitCIMDirty 0x00000002 #define JET_bitAggregateTransaction 0x00000008 /* JetGetLastErrorInfo structure */ typedef struct { unsigned long cbStruct; /* Size of this structure */ JET_ERR err; /* Extended error code (if any) */ unsigned long ul1; /* First general purpose integer */ unsigned long ul2; /* Second general purpose integer */ unsigned long ul3; /* Third general purpose integer */ } JET_EXTERR; /* Status Notification Structures */ typedef struct /* Status Notification Progress */ { unsigned long cbStruct; /* Size of this structure */ unsigned long cunitDone; /* Number of units of work completed */ unsigned long cunitTotal; /* Total number of units of work */ } JET_SNPROG; /* ErrCount Notification Structures */ typedef struct /* Status Notification Progress */ { unsigned long cbStruct; /* Size of this structure */ unsigned long cRecUniqueKeyViolation; unsigned long cRecTypeConversionFail; unsigned long cRecRecordLocked; unsigned long cRecTotal; /* Total number of units of work */ } JET_SNERRCNT; typedef struct /* Status Notification Message */ { unsigned long cbStruct; /* Size of this structure */ JET_SNC snc; /* Status Notification Code */ unsigned long ul; /* Numeric identifier */ char sz[256]; /* Identifier */ } JET_SNMSG; typedef struct { unsigned long cbStruct; JET_OBJTYP objtyp; JET_DATESERIAL dtCreate; JET_DATESERIAL dtUpdate; JET_GRBIT grbit; unsigned long flags; unsigned long cRecord; unsigned long cPage; } JET_OBJECTINFO; typedef struct { unsigned int dbid; char szDatabaseName[256]; char szNewDatabaseName[256]; } JET_RSTMAP; /* restore map */ /* The following flags appear in the grbit field above */ #define JET_bitTableInfoUpdatable 0x00000001 #define JET_bitTableInfoBookmark 0x00000002 #define JET_bitTableInfoRollback 0x00000004 #define JET_bitTableInfoRestartable 0x00000008 #define JET_bitTableInfoNoInserts 0x00000010 /* The following flags occur in the flags field above */ #define JET_bitSaveUIDnPWD 0x20000000 /* this bit is only */ /* appropriate for rmt links */ #define JET_bitObjectExclusive 0x40000000 /* Open link exclusively */ #define JET_bitObjectSystem 0x80000000 typedef struct { unsigned long cbStruct; JET_TABLEID tableid; unsigned long cRecord; JET_COLUMNID columnidcontainername; JET_COLUMNID columnidobjectname; JET_COLUMNID columnidobjtyp; JET_COLUMNID columniddtCreate; JET_COLUMNID columniddtUpdate; JET_COLUMNID columnidgrbit; JET_COLUMNID columnidflags; JET_COLUMNID columnidcRecord; /* Level 2 info */ JET_COLUMNID columnidcPage; /* Level 2 info */ } JET_OBJECTLIST; #define cObjectInfoCols 9 /* CONSIDER: Internal */ typedef struct { unsigned long cbStruct; JET_TABLEID tableid; unsigned long cRecord; JET_COLUMNID columnidSid; JET_COLUMNID columnidACM; JET_COLUMNID columnidgrbit; /* grbit from JetSetAccess */ } JET_OBJECTACMLIST; #define cObjectAcmCols 3 /* CONSIDER: Internal */ typedef struct { unsigned long cbStruct; JET_TABLEID tableid; unsigned long cRecord; JET_COLUMNID columnidPresentationOrder; JET_COLUMNID columnidcolumnname; JET_COLUMNID columnidcolumnid; JET_COLUMNID columnidcoltyp; JET_COLUMNID columnidCountry; JET_COLUMNID columnidLangid; JET_COLUMNID columnidCp; JET_COLUMNID columnidCollate; JET_COLUMNID columnidcbMax; JET_COLUMNID columnidgrbit; JET_COLUMNID columnidDefault; JET_COLUMNID columnidBaseTableName; JET_COLUMNID columnidBaseColumnName; JET_COLUMNID columnidDefinitionName; } JET_COLUMNLIST; #define cColumnInfoCols 14 /* CONSIDER: Internal */ typedef struct { unsigned long cbStruct; JET_COLUMNID columnid; JET_COLTYP coltyp; unsigned short wCountry; unsigned short langid; unsigned short cp; unsigned short wCollate; /* Must be 0 */ unsigned long cbMax; JET_GRBIT grbit; } JET_COLUMNDEF; typedef struct { unsigned long cbStruct; JET_COLUMNID columnid; JET_COLTYP coltyp; unsigned short wCountry; unsigned short langid; unsigned short cp; unsigned short wFiller; /* Must be 0 */ unsigned long cbMax; JET_GRBIT grbit; char szBaseTableName[256]; /* CONSIDER: Too large? */ char szBaseColumnName[256]; /* CONSIDER: Too large? */ } JET_COLUMNBASE; typedef struct { unsigned long cbStruct; JET_TABLEID tableid; unsigned long cRecord; JET_COLUMNID columnidindexname; JET_COLUMNID columnidgrbitIndex; JET_COLUMNID columnidcKey; JET_COLUMNID columnidcEntry; JET_COLUMNID columnidcPage; JET_COLUMNID columnidcColumn; JET_COLUMNID columnidiColumn; JET_COLUMNID columnidcolumnid; JET_COLUMNID columnidcoltyp; JET_COLUMNID columnidCountry; JET_COLUMNID columnidLangid; JET_COLUMNID columnidCp; JET_COLUMNID columnidCollate; JET_COLUMNID columnidgrbitColumn; JET_COLUMNID columnidcolumnname; } JET_INDEXLIST; #define cIndexInfoCols 15 /* CONSIDER: Internal */ typedef struct { unsigned long cbStruct; JET_TABLEID tableid; unsigned long cRecord; JET_COLUMNID columnidReferenceName; JET_COLUMNID columnidgrbit; JET_COLUMNID columnidcColumn; JET_COLUMNID columnidiColumn; JET_COLUMNID columnidReferencingTableName; JET_COLUMNID columnidReferencingColumnName; JET_COLUMNID columnidReferencedTableName; JET_COLUMNID columnidReferencedColumnName; } JET_RELATIONSHIPLIST; /* for backward compatibility */ typedef JET_RELATIONSHIPLIST JET_REFERENCELIST; #define cReferenceInfoCols 8 /* CONSIDER: Internal */ typedef struct { unsigned long cbStruct; unsigned long ibLongValue; unsigned long itagSequence; JET_COLUMNID columnidNextTagged; } JET_RETINFO; typedef struct { unsigned long cbStruct; unsigned long ibLongValue; unsigned long itagSequence; } JET_SETINFO; typedef struct { unsigned long cbStruct; unsigned long centriesLT; unsigned long centriesInRange; unsigned long centriesTotal; } JET_RECPOS; typedef struct { unsigned long cDiscont; unsigned long cUnfixedMessyPage; unsigned long centriesLT; unsigned long centriesTotal; } PERS_OLCSTAT; typedef struct { unsigned long cDiscont; unsigned long cUnfixedMessyPage; unsigned long centriesLT; unsigned long centriesTotal; unsigned long cpgCompactFreed; } JET_OLCSTAT; typedef struct { unsigned long ctableid; JET_TABLEID rgtableid[1]; } JET_MGBLIST; /*** Property Manager Structure ***/ typedef struct { unsigned long cbStruct; JET_TABLEID tableid; JET_COLUMNID columnidColumnName; JET_COLUMNID columnidPropertyName; JET_COLUMNID columnidGrbit; JET_COLUMNID columnidPropertyValue; JET_COLUMNID columnidColtyp; } JET_PROPERTYLIST; /************************************************************************/ /************************* JET CONSTANTS ************************/ /************************************************************************/ #define JET_tableidNil ((JET_TABLEID) 0xFFFFFFFF) #define JET_sesidNil ((JET_SESID) 0xFFFFFFFF) /* Max size of a bookmark */ #define JET_cbBookmarkMost 256 /* Max length of a object/column/index/property name */ #define JET_cbNameMost 64 /* Max length of a "name.name.name..." construct */ #define JET_cbFullNameMost 255 /* Max size of non-long-value column data */ #define JET_cbColumnMost 255 /* Max size of a sort/index key */ #define JET_cbKeyMost 255 /* Max number of components in a sort/index key */ #define JET_ccolKeyMost 10 /* Max number of columns in a table/query */ #define JET_ccolTableMost 255 /* Max Length of a property in the property manager */ #define JET_cbPropertyMost 2048 /* Largest initial substring of a long value used in an expression */ #define JET_cbExprLVMost 0x8000L /*** 32 K ***/ /* Max size of returned (from SQLDriverConnect) conn string */ #define JET_cbConnectMost 255 /* Max number of levels in an MGB */ #define JET_wGroupLevelMax 12 /* Size restrictions for Pins */ #define JET_cchPINMax 20 #define JET_cchPINMin 4 /* System parameter codes for JetSetSystemParameter */ #define JET_paramSysDbPath 0 /* Path to the system database */ #define JET_paramTempPath 1 /* Path to the temporary file directory */ #define JET_paramPfnStatus 2 /* Status callback function */ #define JET_paramPfnError 3 /* Error callback function */ #define JET_paramHwndODBC 4 /* Window handle for ODBC use */ #define JET_paramIniPath 5 /* Path to the ini file */ #define JET_paramPageTimeout 6 /* Red ISAM page timeout value */ #define JET_paramODBCQueryTimeout 7 /* ODBC async query timeout value */ #define JET_paramMaxBuffers 8 /* Bytes to use for page buffers */ #define JET_paramMaxSessions 9 /* Maximum number of sessions */ #define JET_paramMaxOpenTables 10 /* Maximum number of open tables */ #define JET_paramMaxVerPages 11 /* Maximum number of modified pages */ #define JET_paramMaxCursors 12 /* Maximum number of open cursors */ #define JET_paramLogFilePath 13 /* Path to the log file directory */ #define JET_paramMaxOpenTableIndexes 14 /* Maximum open table indexes */ #define JET_paramMaxTemporaryTables 15 /* Maximum concurrent JetCreateIndex */ #define JET_paramLogBuffers 16 /* Maximum log buffers */ #define JET_paramLogFileSectors 17 /* Maximum log sectors per log file */ #define JET_paramLogFlushThreshold 18 /* Log buffer flush threshold */ #define JET_paramBfThrshldLowPrcnt 19 /* Low threshold ( % ) for buffers */ #define JET_paramBfThrshldHighPrcnt 20 /* High threshold ( % ) for buffers */ #define JET_paramWaitLogFlush 21 /* msec for waiting log flush */ #define JET_paramLogFlushPeriod 22 /* msec for waiting log flush */ #define JET_paramLogCheckpointPeriod 23 /* msec for waiting log flush */ #define JET_paramLogWaitingUserMax 24 /* Maximum # user waiting log flush */ #define JET_paramODBCLoginTimeout 25 /* ODBC connection attempt timeout value */ #define JET_paramExprObject 26 /* Expression Evaluation callback */ #define JET_paramGetTypeComp 27 /* Expression Evaluation callback */ #define JET_paramHostVersion 28 /* Host Version callback */ #define JET_paramSQLTraceMode 29 /* Enable/disable SQL tracing */ #define JET_paramRecovery 30 /* Switch for log on/off */ #define JET_paramRestorePath 31 /* Path to restoring directory */ #define JET_paramTransactionLevel 32 /* Transaction level of session */ #define JET_paramSessionInfo 33 /* Session info */ #define JET_paramPageFragment 34 /* Largest page extent considered fragment */ #define JET_paramJetInternal 35 /* Whether internal to JET; if set, allows ISAM to do things which are prevented in general */ #define JET_paramMaxOpenDatabases 36 /* Maximum number of open databases */ #define JET_paramOnLineCompact 37 /* Options for compact pages on-line */ #define JET_paramFullQJet 38 /* Allow full QJet functionality */ #define JET_paramRmtXactIsolation 39 /* Do not share connections with other sessions */ #define JET_paramBufLRUKCorrInterval 40 #define JET_paramBufBatchIOMax 41 #define JET_paramPageReadAheadMax 42 #define JET_paramAsynchIOMax 43 #define JET_paramAssertAction 44 /* debug only determines action on assert */ #define JET_paramEventSource 45 /* NT event log */ #define JET_paramEventId 46 /* NT event id */ #define JET_paramEventCategory 47 /* NT event category */ /* Flags for JetIdle */ #define JET_bitIdleRemoveReadLocks 0x00000001 #define JET_bitIdleFlushBuffers 0x00000002 #define JET_bitIdleCompact 0x00000004 /* Flags for JetEndSession */ #define JET_bitForceSessionClosed 0x00000001 /* Flags for JetOpenDatabase */ #define JET_bitDbReadOnly 0x00000001 #define JET_bitDbExclusive 0x00000002 /* multiple opens allowed */ #define JET_bitDbRemoteSilent 0x00000004 #define JET_bitDbSingleExclusive 0x00000008 /* opened exactly once */ /* Flags for JetCloseDatabase */ #define JET_bitDbForceClose 0x00000001 /* Flags for JetCreateDatabase */ #define JET_bitDbEncrypt 0x00000001 #define JET_bitDbVersion10 0x00000002 #define JET_bitDbVersion1x 0x00000004 #define JET_bitDbRecoveryOff 0x00000008 /* disable logging/recovery */ #define JET_bitDbNoLogging 0x00000010 /* no logging */ #define JET_bitDbCompleteConnstr 0x00000020 /* Flags for JetBackup */ #define JET_bitBackupIncremental 0x00000001 #define JET_bitKeepOldLogs 0x00000002 #define JET_bitOverwriteExisting 0x00000004 /* Database types */ #define JET_dbidNil ((JET_DBID) 0xFFFFFFFF) #define JET_dbidNoValid ((JET_DBID) 0xFFFFFFFE) /* used as a flag to indicate that there is no valid dbid */ /* Flags for JetCreateLink */ /* Can use JET_bitObjectExclusive to cause linked to database to be opened */ /* exclusively. */ /* Flags for JetAddColumn, JetGetColumnInfo, JetOpenTempTable */ #define JET_bitColumnFixed 0x00000001 #define JET_bitColumnTagged 0x00000002 #define JET_bitColumnNotNULL 0x00000004 #define JET_bitColumnVersion 0x00000008 #define JET_bitColumnAutoincrement 0x00000010 #define JET_bitColumnUpdatable 0x00000020 /* JetGetColumnInfo only */ #define JET_bitColumnTTKey 0x00000040 /* JetOpenTempTable only */ #define JET_bitColumnTTDescending 0x00000080 /* JetOpenTempTable only */ #define JET_bitColumnNotLast 0x00000100 /* Installable ISAM option */ #define JET_bitColumnRmtGraphic 0x00000200 /* JetGetColumnInfo */ #define JET_bitColumnMultiValued 0x00000400 /* Flags for JetMakeKey */ #define JET_bitNewKey 0x00000001 #define JET_bitStrLimit 0x00000002 #define JET_bitSubStrLimit 0x00000004 #define JET_bitNormalizedKey 0x00000008 #define JET_bitKeyDataZeroLength 0x00000010 #ifdef DBCS /* johnta: LIKE "ABC" not converted to ="ABC" for Japanese */ #define JET_bitLikeExtra1 0x00000020 #endif /* DBCS */ /* Flags for ErrDispSetIndexRange */ #define JET_bitRangeInclusive 0x00000001 /* CONSIDER: Internal */ #define JET_bitRangeUpperLimit 0x00000002 /* CONSIDER: Internal */ /* Constants for JetMove */ #define JET_MoveFirst (0x80000000) #define JET_MovePrevious (-1) #define JET_MoveNext (+1) #define JET_MoveLast (0x7fffffff) /* Flags for JetMove */ #define JET_bitMoveKeyNE 0x00000001 #define JET_bitMoveCheckTS 0x00000002 #define JET_bitMoveInPage 0x00000004 /* Flags for JetSeek */ #define JET_bitSeekEQ 0x00000001 #define JET_bitSeekLT 0x00000002 #define JET_bitSeekLE 0x00000004 #define JET_bitSeekGE 0x00000008 #define JET_bitSeekGT 0x00000010 #define JET_bitSetIndexRange 0x00000020 /* Flags for JetFastFind */ #define JET_bitFFindBackwards 0x00000001 #define JET_bitFFindFromCursor 0x00000004 /* Flags for JetCreateIndex */ #define JET_bitIndexUnique 0x00000001 #define JET_bitIndexPrimary 0x00000002 #define JET_bitIndexDisallowNull 0x00000004 #define JET_bitIndexIgnoreNull 0x00000008 #define JET_bitIndexClustered 0x00000010 #define JET_bitIndexIgnoreAnyNull 0x00000020 #define JET_bitIndexReference 0x80000000 /* IndexInfo only */ /* Flags for index key definition */ #define JET_bitKeyAscending 0x00000000 #define JET_bitKeyDescending 0x00000001 /* Flags for JetCreateRelationship */ #define JET_bitRelationUnique 0x00000001 #define JET_bitRelationDontEnforce 0x00000002 #define JET_bitRelationInherited 0x00000004 #define JET_bitRelationTestLegal 0x00000008 /* don't create relationship */ #define JET_bitRelationshipMatchMask 0x000000F0 #define JET_bitRelationMatchDefault 0x00000000 #define JET_bitRelationMatchFull 0x00000010 #define JET_bitRelationUpdateActionMask 0x00000F00 #define JET_bitRelationUpdateDisallow 0x00000000 #define JET_bitRelationUpdateCascade 0x00000100 #define JET_bitRelationUpdateSetNull 0x00000200 #define JET_bitRelationUpdateSetDefault 0x00000300 #define JET_bitRelationDeleteActionMask 0x0000F000 #define JET_bitRelationDeleteDisallow 0x00000000 #define JET_bitRelationDeleteCascade 0x00001000 #define JET_bitRelationDeleteSetNull 0x00002000 #define JET_bitRelationDeleteSetDefault 0x00003000 #define JET_bitRelationUserMask 0xFF000000 /* non-enforced values */ #define JET_bitRelationJoinMask 0x03000000 #define JET_bitRelationInner 0x00000000 #define JET_bitRelationLeft 0x01000000 #define JET_bitRelationRight 0x02000000 /* Flags for JetCreateReference/JetCreateRelationship */ /* NOTE: use the bitRelationship flags instead! */ #define JET_ReferenceUnique JET_bitRelationUnique #define JET_ReferenceDontEnforce JET_bitRelationDontEnforce #define JET_ReferenceMatchTypeMask JET_bitRelationMatchMask #define JET_ReferenceMatchDefault JET_bitRelationMatchDefault #define JET_ReferenceMatchFull JET_bitRelationMatchFull #define JET_ReferenceUpdateActionMask JET_bitRelationUpdateActionMask #define JET_ReferenceUpdateDisallow JET_bitRelationUpdateDisallow #define JET_ReferenceUpdateCascade JET_bitRelationUpdateCascade #define JET_ReferenceUpdateSetNull JET_bitRelationUpdateSetNull #define JET_ReferenceUpdateSetDefault JET_bitRelationUpdateSetDefault #define JET_ReferenceDeleteActionMask JET_bitRelationDeleteActionMask #define JET_ReferenceDeleteDisallow JET_bitRelationDeleteDisallow #define JET_ReferenceDeleteCascade JET_bitRelationDeleteCascade #define JET_ReferenceDeleteSetNull JET_bitRelationDeleteSetNull #define JET_ReferenceDeleteSetDefault JET_bitRelationDeleteSetDefault /* Flags for JetOpenTable */ #define JET_bitTableDenyWrite 0x00000001 #define JET_bitTableDenyRead 0x00000002 #define JET_bitTableReadOnly 0x00000004 #define JET_bitTableAppendOnly 0x00000008 #define JET_bitTableUpdatable 0x00000010 #define JET_bitTableScrollable 0x00000020 #define JET_bitTableFixedSet 0x00000040 /* Fixed working set */ #define JET_bitTableInconsistent 0x00000080 #define JET_bitTableBulk 0x00000100 #define JET_bitTableUsePrimaryIndex 0x00000200 /* Use with FixedSet */ #define JET_bitTableSampleData 0x00000400 #define JET_bitTableQuickBrowse 0x00000800 /* Bias optimizer toward index usage */ #define JET_bitTableDDL 0x00001000 /* similar to JET_bitTableBulk, for DDL */ #define JET_bitTablePassThrough 0x00002000 /* Remote DBs Only */ #define JET_bitTableRowReturning 0x00004000 /* Flags for JetSetQoSql/JetRetrieveQoSql */ #define JET_bitSqlPassThrough 0x00000001 /* Pass through Query returning records */ #define JET_bitSqlSPTBulkOp 0x00000002 /* SPT query returning no table */ /* Flags for JetOpenVtQbe */ #define JET_bitQBEAddBrackets 0x00000001 #define JET_bitQBERemoveEquals 0x00000002 /* Flags for JetOpenTempTable and ErrIsamOpenTempTable */ #define JET_bitTTIndexed 0x00000001 /* Allow seek */ #define JET_bitTTUnique 0x00000002 /* Remove duplicates */ #define JET_bitTTUpdatable 0x00000004 /* Allow updates */ #define JET_bitTTScrollable 0x00000008 /* Allow backwards scrolling */ /* Flags for JetSetColumn */ #define JET_bitSetAppendLV 0x00000001 #define JET_bitSetValidate 0x00000002 #define JET_bitSetOverwriteLV 0x00000004 #define JET_bitSetSizeLV 0x00000008 #define JET_bitSetValidateColumn 0x00000010 #define JET_bitSetZeroLength 0x00000020 /* Set column parameter structure for JetSetColumns */ typedef struct { JET_COLUMNID columnid; const void _far *pvData; unsigned long cbData; JET_GRBIT grbit; unsigned long ibLongValue; unsigned long itagSequence; JET_ERR err; } JET_SETCOLUMN; /* Options for JetPrepareUpdate */ #define JET_prepInsert 0 #define JET_prepInsertBeforeCurrent 1 #define JET_prepReplace 2 #define JET_prepCancel 3 #define JET_prepReplaceNoLock 4 #define JET_prepInsertCopy 5 /* Flags for JetRetrieveColumn */ #define JET_bitRetrieveCopy 0x00000001 #define JET_bitRetrieveFromIndex 0x00000002 #define JET_bitRetrieveCase 0x00000004 #define JET_bitRetrieveTag 0x00000008 #define JET_bitRetrieveRecord 0x80000000 #define JET_bitRetrieveFDB 0x40000000 #define JET_bitRetrieveBookmarks 0x20000000 /* Retrieve column parameter structure for JetRetrieveColumns */ typedef struct { JET_COLUMNID columnid; void _far *pvData; unsigned long cbData; unsigned long cbActual; JET_GRBIT grbit; unsigned long ibLongValue; unsigned long itagSequence; JET_COLUMNID columnidNextTagged; JET_ERR err; } JET_RETRIEVECOLUMN; /* Flags for JetFillFatCursor */ #define JET_bitFCFillRange 0x00000001 #define JET_bitFCRefreshRange 0x00000002 #define JET_bitFCFillMemos 0x00000004 /* Flags for JetCommitTransaction */ #define JET_bitCommitFlush 0x00000001 /* Flags for JetRollback */ #define JET_bitRollbackAll 0x00000001 /* Flags for JetSetAccess and JetGetAccess */ #define JET_bitACEInheritable 0x00000001 /* Flags for JetCreateSystemDatabase */ #define JET_bitSysDbOverwrite 0x00000001 /* Flags for Jet Property Management */ #define JET_bitPropDDL 0x00000001 /* also used for setting */ #define JET_bitPropInherited 0x00000002 /* not used for setting */ /* JPM Flags that are only used for setting properties */ #define JET_bitPropReplaceOnly 0x00000010 #define JET_bitPropInsertOnly 0x00000020 #define JET_bitPropDeleteOnly 0x00000040 /* InfoLevels for Jet Property Management */ #define JET_PropertyValue 0 #define JET_PropertyCount 1 #define JET_PropertySingleCollection 2 #define JET_PropertyAllCollections 3 /* Collate values for JetGetColumnInfo and JetGetIndexInfo */ #define JET_sortBinary 0x0000 #define JET_sortEFGPI 0x0100 #define JET_sortSNIFD 0x0101 #define JET_sortSpanish 0x0102 #define JET_sortDutch 0x0103 #define JET_sortSweFin 0x0104 #define JET_sortNorDan 0x0105 #define JET_sortIcelandic 0x0106 #define JET_sortCyrillic 0x0107 #define JET_sortCzech 0x0108 #define JET_sortHungarian 0x0109 #define JET_sortPolish 0x010A #define JET_sortArabic 0x010B #define JET_sortHebrew 0x010C #define JET_sortMax 0x010C /* Max for nonDBCS sort orders */ #ifdef DBCS /* johnta: Add the new Japanese sorting order */ #define JET_sortJapanese 0x010D #endif /* DBCS */ #define JET_sortUnknown 0xFFFF /* Paradox ISAM specific collate values */ #define JET_sortPdxIntl 0x1000 #define JET_sortPdxSwedFin 0x1001 #define JET_sortPdxNorDan 0x1002 /* Info parameter for JetGetDatabaseInfo */ #define JET_DbInfoFilename 0 #define JET_DbInfoConnect 1 #define JET_DbInfoCountry 2 #define JET_DbInfoLangid 3 #define JET_DbInfoCp 4 #define JET_DbInfoCollate 5 #define JET_DbInfoOptions 6 #define JET_DbInfoTransactions 7 #define JET_DbInfoVersion 8 #define JET_DbInfoIsam 9 /* Database versions returned by JetGetDatabaseInfo */ #define JET_DbVersion10 0x00010000 #define JET_DbVersion11 0x00010001 #define JET_DbVersion20 0x00020000 /* Isam specific info returned by JetGetDatabaseInfo */ #define JET_IsamInvalid 0 #define JET_IsamBuiltinRed 1 #define JET_IsamBuiltinBlue 2 #define JET_IsamInstRed 21 #define JET_IsamInstBlue 22 #define JET_IsamInstFox 23 #define JET_IsamInstParadox 24 #define JET_IsamInstDbase 25 #define JET_IsamInstBtrieve 26 #define JET_IsamBuilinMost JET_BuiltinBlue #define JET_IsamInstMin JET_IsamInstRed #define JET_IsamInstMost JET_IsamInstBtrieve /* Link specific info for link identification */ #define JET_bitLinkInvalid 0x00000000 #define JET_bitLinkRemote 0x00100000 #define JET_bitLinkBuiltinRed 0x00200000 #define JET_bitLinkBuiltinBlue 0x00300000 #define JET_bitLinkInstRed 0x00400000 #define JET_bitLinkInstBlue 0x00500000 #define JET_bitLinkInstFox 0x00600000 #define JET_bitLinkInstParadox 0x00700000 #define JET_bitLinkInstDbase 0x00800000 #define JET_bitLinkInstBtrieve 0x00900000 #define JET_bitFourByteBookmark 0x00000001 #define JET_bitContiguousBookmarks 0x00000002 /* Column data types */ /* the column types are represented with 4 bits */ /* make sure the choices below fit! */ /* NOTE: all comb of the 4 bits are now used! */ /* CONSIDER: to allow more datatypes, either */ /* CONSIDER: JET_coltypDatabase and JET_coltypTableid must */ /* CONSIDER: change or the 4 bit dependancy must be removed */ #define JET_coltypNil 0 #define JET_coltypBit 1 /* True or False, Never NULL */ #define JET_coltypUnsignedByte 2 /* 1-byte integer, unsigned */ #define JET_coltypShort 3 /* 2-byte integer, signed */ #define JET_coltypLong 4 /* 4-byte integer, signed */ #define JET_coltypCurrency 5 /* 8 byte integer, signed */ #define JET_coltypIEEESingle 6 /* 4-byte IEEE single precision */ #define JET_coltypIEEEDouble 7 /* 8-byte IEEE double precision */ #define JET_coltypDateTime 8 /* Integral date, fractional time */ #define JET_coltypBinary 9 /* Binary data, < 255 bytes */ #define JET_coltypText 10 /* ANSI text, case insensitive, < 255 bytes */ #define JET_coltypLongBinary 11 /* Binary data, long value */ #define JET_coltypLongText 12 /* ANSI text, long value */ /* The following are additional types used for query parameters */ /* NOTE: Code depends on these being contiguous with the normal coltyps */ /* CONSIDER: Remove the above dependency on contiguous coltyps in QJET */ #define JET_coltypDatabase 13 /* Database name parameter */ #define JET_coltypTableid 14 /* Tableid parameter */ #define JET_coltypOLE 15 /* OLE blob */ #define JET_coltypMax 16 /* the number of column types */ /* used for validity tests and */ /* array declarations. */ /* Info levels for JetGetObjectInfo */ #define JET_ObjInfo 0U #define JET_ObjInfoListNoStats 1U #define JET_ObjInfoList 2U #define JET_ObjInfoSysTabCursor 3U #define JET_ObjInfoListACM 4U /* Blocked by JetGetObjectInfo */ #define JET_ObjInfoNoStats 5U #define JET_ObjInfoSysTabReadOnly 6U #define JET_ObjInfoRulesLoaded 7U #define JET_ObjInfoMax 8U /* Info levels for JetGetTableInfo */ #define JET_TblInfo 0U #define JET_TblInfoName 1U #define JET_TblInfoDbid 2U #define JET_TblInfoMostMany 3U #define JET_TblInfoRvt 4U #define JET_TblInfoOLC 5U #define JET_TblInfoResetOLC 6U #define JET_TblInfoSpaceUsage 7U #define JET_TblInfoDumpTable 8U /* Info levels for JetGetIndexInfo and JetGetTableIndexInfo */ #define JET_IdxInfo 0U #define JET_IdxInfoList 1U #define JET_IdxInfoSysTabCursor 2U #define JET_IdxInfoOLC 3U #define JET_IdxInfoResetOLC 4U /* Info levels for JetGetReferenceInfo and JetGetTableReferenceInfo */ #define JET_ReferenceInfo 0U #define JET_ReferenceInfoReferencing 1U #define JET_ReferenceInfoReferenced 2U #define JET_ReferenceInfoAll 3U #define JET_ReferenceInfoCursor 4U /* Info levels for JetGetColumnInfo and JetGetTableColumnInfo */ #define JET_ColInfo 0U #define JET_ColInfoList 1U /* CONSIDER: Info level 2 is valid */ #define JET_ColInfoSysTabCursor 3U #define JET_ColInfoBase 4U /* Attribute types for query definitions */ #define JET_qoaBeginDef 0 #define JET_qoaOperation 1 #define JET_qoaParameter 2 #define JET_qoaOptions 3 #define JET_qoaDatabase 4 #define JET_qoaInputTable 5 #define JET_qoaOutput 6 #define JET_qoaJoin 7 #define JET_qoaRestriction 8 #define JET_qoaGroup 9 #define JET_qoaGroupRstr 10 #define JET_qoaOrdering 11 #define JET_qoaEndDef 255 #define JET_qoaValidLeast JET_qoaOperation #define JET_qoaValidMost JET_qoaOrdering /* Query object options */ #define JET_bitFqoOutputAllCols 0x0001 #define JET_bitFqoRemoveDups 0x0002 #define JET_bitFqoOwnerAccess 0x0004 #define JET_bitFqoDistinctRow 0x0008 #define JET_bitFqoTop 0x0010 #define JET_bitFqoPercent 0x0020 #define JET_bitFqoCorresponding 0x0040 /* JET_qopSetOperation */ /* Query object join type */ #define JET_fjoinInner 1 #define JET_fjoinLeftOuter 2 #define JET_fjoinRightOuter 3 /* Query object operations */ #define JET_qopSelect 1 #define JET_qopSelectInto 2 #define JET_qopInsertSelection 3 #define JET_qopUpdate 4 #define JET_qopDelete 5 #define JET_qopTransform 6 #define JET_qopDDL 7 #define JET_qopSqlPassThrough 8 #define JET_qopSetOperation 9 #define JET_qopSPTBulk 10 #define JET_bitqopSelect 0x0000 #define JET_bitqopTransform 0x0010 #define JET_bitqopDelete 0x0020 #define JET_bitqopUpdate 0x0030 #define JET_bitqopInsertSelection 0x0040 #define JET_bitqopSelectInto 0x0050 #define JET_bitqopDDL 0x0060 #define JET_bitqopSqlPassThrough 0x0070 #define JET_bitqopSetOperation 0x0080 #define JET_bitqopSPTBulk 0x0090 /* Engine Object Types */ #define JET_objtypNil 0 #define JET_objtypTable 1 #define JET_objtypDb 2 #define JET_objtypContainer 3 #define JET_objtypSQLLink 4 #define JET_objtypQuery 5 #define JET_objtypLink 6 #define JET_objtypTemplate 7 #define JET_objtypRelationship 8 /* All types less than JET_objtypClientMin are reserved by JET */ #define JET_objtypClientMin 0x8000 /* Security Constant Values */ #define JET_cchUserNameMax 20 #define JET_cchPasswordMax 14 /* Security Access Masks */ #define JET_acmNoAccess 0x00000000L #define JET_acmFullAccess 0x000FFFFFL #define JET_acmSpecificMask 0x0000FFFFL #define JET_acmSpecific_1 0x00000001L #define JET_acmSpecific_2 0x00000002L #define JET_acmSpecific_3 0x00000004L #define JET_acmSpecific_4 0x00000008L #define JET_acmSpecific_5 0x00000010L #define JET_acmSpecific_6 0x00000020L #define JET_acmSpecific_7 0x00000040L #define JET_acmSpecific_8 0x00000080L #define JET_acmSpecific_9 0x00000100L #define JET_acmSpecific_10 0x00000200L #define JET_acmSpecific_11 0x00000400L #define JET_acmSpecific_12 0x00000800L #define JET_acmSpecific_13 0x00001000L #define JET_acmSpecific_14 0x00002000L #define JET_acmSpecific_15 0x00004000L #define JET_acmSpecific_16 0x00008000L #define JET_acmStandardMask 0x00FF0000L #define JET_acmDelete 0x00010000L #define JET_acmReadControl 0x00020000L #define JET_acmWriteDac 0x00040000L #define JET_acmWriteOwner 0x00080000L #define JET_acmTblCreate (JET_acmSpecific_1) #define JET_acmTblAccessRcols (JET_acmSpecific_2) #define JET_acmTblReadDef (JET_acmSpecific_3) #define JET_acmTblWriteDef (JET_acmSpecific_4) #define JET_acmTblRetrieveData (JET_acmSpecific_5) #define JET_acmTblInsertData (JET_acmSpecific_6) #define JET_acmTblReplaceData (JET_acmSpecific_7) #define JET_acmTblDeleteData (JET_acmSpecific_8) #define JET_acmDbCreate (JET_acmSpecific_1) #define JET_acmDbOpen (JET_acmSpecific_2) /* Compact Options */ #define JET_bitCompactEncrypt 0x00000001 /* Dest is encrypted */ #define JET_bitCompactDecrypt 0x00000002 /* Dest is not encrypted */ #define JET_bitCompactDontCopyLocale 0x00000004 /* Don't copy locale from source to dest */ #define JET_bitCompactVersion10 0x00000008 /* Destination is version 1.0 format */ #define JET_bitCompactVersion1x 0x00000010 /* Destination is version 1.x format */ /* On-line Compact Options */ #define JET_bitCompactOn 0x00000001 /* enable on-line compaction */ /* Repair Notification Types */ #define JET_rntSelfContained 0 /* CONSIDER: These are SNCs */ #define JET_rntDeletedIndex 1 #define JET_rntDeletedRec 2 #define JET_rntDeletedLv 3 #define JET_rntTruncated 4 /* Status Notification Processes */ #define JET_snpIndex 0 #define JET_snpQuery 1 #define JET_snpRepair 2 #define JET_snpImex 3 #define JET_snpCompact 4 #define JET_snpFastFind 5 #define JET_snpODBCNotReady 6 #define JET_snpQuerySort 7 #define JET_snpRestore 8 /* Status Notification Types */ #define JET_sntProgress 0 /* callback for progress */ #define JET_sntMessage 1 #define JET_sntBulkRecords 2 /* callback for # rec for bulk op */ #define JET_sntFail 3 /* callback for failure during progress */ #define JET_sntErrCount 4 /* callback for err count */ #define JET_sntBegin 5 /* callback for beginning of operation */ #define JET_sntComplete 6 /* callback for completion of operation */ #define JET_sntCantRollback 7 /* callback for no rollback */ #define JET_sntRestoreMap 8 /* callback for restore map */ /* Message codes for JET_snpCompact */ #define JET_sncCopyObject 0 /* Starting to copy object */ #define JET_sncCopyFailed 1 /* Copy of this object failed */ #define JET_sncYield 2 /* Client can yield/check for user interrupt */ #define JET_sncTransactionFull 3 /* Client can yield/check for user interrupt */ #define JET_sncAboutToWrap 4 /* Find find is about to wrap */ /* Message codes for JET_snpODBCNotReady */ #define JET_sncODBCNotReady 0 /* Waiting for results from ODBC */ /* Constants for the [ODBC] section of JET.INI */ #define JET_SQLTraceCanonical 0x0001 /* Output ODBC Generic SQL */ /* Constants for the [Debug] section of JET.INI */ /* APITrace */ #define JET_APITraceEnter 0x0001 #define JET_APITraceExit 0x0002 #define JET_APITraceExitError 0x0004 #define JET_APIBreakOnError 0x0008 #define JET_APITraceCount 0x0010 #define JET_APITraceNoIdle 0x0020 #define JET_APITraceParameters 0x0040 /* IdleTrace */ #define JET_IdleTraceCursor 0x0001 #define JET_IdleTraceBuffer 0x0002 #define JET_IdleTraceFlush 0x0004 /* AssertAction */ #define JET_AssertExit 0x0000 /* Exit the application */ #define JET_AssertBreak 0x0001 /* Break to debugger */ #define JET_AssertMsgBox 0x0002 /* Display message box */ #define JET_AssertStop 0x0004 /* Alert and stop */ /* IOTrace */ #define JET_IOTraceAlloc 0x0001 /* DB Page Allocation */ #define JET_IOTraceFree 0x0002 /* DB Page Free */ #define JET_IOTraceRead 0x0004 /* DB Page Read */ #define JET_IOTraceWrite 0x0008 /* DB Page Write */ #define JET_IOTraceError 0x0010 /* DB Page I/O Error */ /* MemTrace */ #define JET_MemTraceAlloc 0x0001 /* Memory allocation */ #define JET_MemTraceRealloc 0x0002 /* Memory reallocation */ #define JET_MemTraceFree 0x0004 /* Memory free */ /* RmtTrace */ #define JET_RmtTraceError 0x0001 /* Remote server error message */ #define JET_RmtTraceSql 0x0002 /* Remote SQL Prepares & Exec's */ #define JET_RmtTraceAPI 0x0004 /* Remote ODBC API calls */ #define JET_RmtTraceODBC 0x0008 #define JET_RmtSyncODBC 0x0010 /* Turn on ODBC Sync mode */ /**********************************************************************/ /*********************** ERROR CODES **************************/ /**********************************************************************/ /* SUCCESS */ #define JET_errSuccess 0 /* Successful Operation */ /* ERRORS */ #define JET_wrnNyi -1 /* Function Not Yet Implemented */ /* SYSTEM errors /**/ #define JET_errRfsFailure -100 /* JET_errRfsFailure */ #define JET_errRfsNotArmed -101 /* JET_errRfsFailure */ #define JET_errFileClose -102 /* Could not close DOS file */ #define JET_errNoMoreThreads -103 /* Could not start thread */ #define JET_errNoComputerName -104 /* fail to get computername */ #define JET_errTooManyIO -105 /* System busy due to too many IOs */ /* BUFFER MANAGER errors /**/ #define wrnBFNotSynchronous 200 /* Buffer page evicted */ #define wrnBFPageNotFound 201 /* Page not found */ #define errBFInUse -202 /* Cannot abandon buffer */ /* DIRECTORY MANAGER errors /**/ #define errPMOutOfPageSpace -300 /* Out of page space */ #define errPMItagTooBig -301 /* Itag too big */ #define errPMRecDeleted -302 /* Record deleted */ #define errPMTagsUsedUp -303 /* Tags used up */ #define wrnBMConflict 304 /* conflict in BM Clean up */ #define errDIRNoShortCircuit -305 /* No Short Circuit Avail */ #define errDIRCannotSplit -306 /* Cannot horizontally split FDP */ #define errDIRTop -307 /* Cannot go up */ #define errDIRFDP 308 /* On an FDP Node */ #define errDIRNotSynchronous -309 /* May have left critical section */ #define wrnDIREmptyPage 310 /* Moved through empty page */ #define errSPConflict -311 /* Device extent being extended */ #define wrnNDFoundLess 312 /* Found Less */ #define wrnNDFoundGreater 313 /* Found Greater */ #define errNDOutSonRange -314 /* Son out of range */ #define errNDOutItemRange -315 /* Item out of range */ #define errNDGreaterThanAllItems -316 /* Greater than all items */ #define errNDLastItemNode -317 /* Last node of item list */ #define errNDFirstItemNode -318 /* First node of item list */ #define wrnNDDuplicateItem 319 /* Duplicated Item */ #define errNDNoItem -320 /* Item not there */ #define JET_wrnRemainingVersions 321 /* Some versions couldn't be cleaned */ #define JET_wrnPreviousVersion 322 /* Version already existed */ #define JET_errPageBoundary -323 /* Reached Page Boundary */ #define JET_errKeyBoundary -324 /* Reached Key Boundary */ #define errDIRInPageFather -325 /* sridFather in page to free /* RECORD MANAGER errors /**/ #define wrnFLDKeyTooBig 400 /* Key too big (truncated it) */ #define errFLDTooManySegments -401 /* Too many key segments */ #define wrnFLDNullKey 402 /* Key is entirely NULL */ #define wrnFLDOutOfKeys 403 /* No more keys to extract */ #define wrnFLDNullSeg 404 /* Null segment in key */ #define wrnRECLongField 405 /* Separated long field */ #define JET_wrnRecordFoundGreater JET_wrnSeekNotEqual #define JET_wrnRecordFoundLess JET_wrnSeekNotEqual #define JET_errColumnIllegalNull JET_errNullInvalid /* LOGGING/RECOVERY errors /**/ #define JET_errRestoreFailed -500 /* Restore failed */ #define JET_errLogFileCorrupt -501 /* Log file is corrupt */ #define errLGNoMoreRecords -502 /* Last log record read */ #define JET_errNoBackupDirectory -503 /* No backup directory given */ #define JET_errBackupDirectoryNotEmpty -504 /* The backup directory is not emtpy */ #define JET_errBackupInProgress -505 /* Backup is active already */ #define JET_errFailRestoreDatabase -506 /* Fail to restore (copy) database */ #define JET_errNoDatabasesForRestore -507 /* No databases for restor found */ #define JET_errMissingLogFile -508 /* jet.log for restore is missing */ #define JET_errMissingPreviousLogFile -509 /* Missing the log file for check point */ #define JET_errLogWriteFail -510 /* Fail when writing to log file */ #define JET_errLogNotContigous -511 /* Fail to incremental backup for non-contiguous generation number */ #define JET_errFailToMakeTempDirectory -512 /* Fail to make a temp directory */ #define JET_errFailToCleanTempDirectory -513 /* Fail to clean up temp directory */ #define JET_errBadLogVersion -514 /* Version of log file is not compatible with Jet version */ #define JET_errBadNextLogVersion -515 /* Version of next log file is not compatible with current one */ #define JET_errLoggingDisabled -516 /* Log is not active */ #define JET_errLogBufferTooSmall -517 /* Log buffer is too small for recovery */ #define errLGNotSynchronous -518 /* retry to LGLogRec */ #define JET_errFeatureNotAvailable -1001 /* API not supported */ #define JET_errInvalidName -1002 /* Invalid name */ #define JET_errInvalidParameter -1003 /* Invalid API parameter */ #define JET_wrnColumnNull 1004 /* Column is NULL-valued */ #define JET_errReferenceNotFound -1005 /* No such reference */ #define JET_wrnBufferTruncated 1006 /* Buf too short, data truncated */ #define JET_wrnDatabaseAttached 1007 /* Database is already attached */ #define JET_wrnOnEndPoint 1008 /* On end point */ #define JET_wrnSortOverflow 1009 /* Sort does not fit in memory */ #define JET_errInvalidDatabaseId -1010 /* Invalid database id */ #define JET_errOutOfMemory -1011 /* Out of Memory */ #define JET_errCantAllocatePage -1012 /* Couldn't allocate a page */ #define JET_errNoMoreCursors -1013 /* Max # of cursors allocated */ #define JET_errOutOfBuffers -1014 /* JET_errOutOfBuffers */ #define JET_errTooManyIndexes -1015 /* Too many indexes */ #define JET_errTooManyKeys -1016 /* Too many columns in an index */ #define JET_errRecordDeleted -1017 /* Record has been deleted */ #define JET_errReadVerifyFailure -1018 /* Read verification error */ #define JET_errFilesysVersion -1019 /* Obsolete database format */ #define JET_errNoMoreFiles -1020 /* No more file handles */ #define JET_errDiskNotReady -1021 /* Disk not ready */ #define JET_errDiskIO -1022 /* JET_errDiskIO */ #define JET_errInvalidPath -1023 /* JET_errInvalidPath */ #define JET_errFileShareViolation -1024 /* JET_errFileShareViolation */ #define JET_errFileLockViolation -1025 /* JET_errFileLockViolation */ #define JET_errRecordTooBig -1026 /* JET_errRecordTooBig */ #define JET_errTooManyOpenDatabases -1027 /* Database limit reached */ #define JET_errInvalidDatabase -1028 /* This isn't a database */ #define JET_errNotInitialized -1029 /* JetInit not yet called */ #define JET_errAlreadyInitialized -1030 /* JetInit already called */ #define JET_errFileLockingUnavailable -1031 /* JET_errFileLockingUnavailable */ #define JET_errFileAccessDenied -1032 /* JET_errFileAccessDenied */ #define JET_errSharingBufferExceeded -1033 /* OS sharing buffer exceeded */ #define JET_errQueryNotSupported -1034 /* Query support unavailable */ #define JET_errSQLLinkNotSupported -1035 /* SQL Link support unavailable */ #define JET_errTaskLimitExceeded -1036 /* Too many client tasks */ #define JET_errUnsupportedOSVersion -1037 /* Unsupported OS version */ #define JET_errBufferTooSmall -1038 /* Buffer is too small */ #define JET_wrnSeekNotEqual 1039 /* SeekLE or SeekGE didn't find exact match */ #define JET_errTooManyColumns -1040 /* Too many columns defined */ #define JET_errTooManyFixedColumns -1041 /* Too many fixed columns defined */ #define JET_errTooManyVariableColumns -1042 /* Too many variable columns defined */ #define JET_errContainerNotEmpty -1043 /* Container is not empty */ #define JET_errInvalidFilename -1044 /* Filename is invalid */ #define JET_errInvalidBookmark -1045 /* Invalid bookmark */ #define JET_errColumnInUse -1046 /* Column used in an index */ #define JET_errInvalidBufferSize -1047 /* Data buffer doesn't match column size */ #define JET_errColumnNotUpdatable -1048 /* Can't set column value */ #define JET_wrnCommitNotFlushed 1049 /* Commit did not flush to disk */ #define JET_errAbortSalvage -1050 /* Forced Salvager abort */ #define JET_errIndexInUse -1051 /* Index is in use */ #define JET_errLinkNotSupported -1052 /* Link support unavailable */ #define JET_errNullKeyDisallowed -1053 /* Null keys are disallowed on index */ #define JET_errNotInTransaction -1054 /* JET_errNotInTransaction */ #define JET_wrnNoErrorInfo 1055 /* No extended error information */ #define JET_errInstallableIsamNotFound -1056 /* Installable ISAM not found */ #define JET_errOperationCancelled -1057 /* Operation canceled by client */ #define JET_wrnNoIdleActivity 1058 /* No idle activity occured */ #define JET_errTooManyActiveUsers -1059 /* Too many active database users */ #define JET_errInvalidAppend -1060 /* Cannot append long value */ #define JET_errInvalidCountry -1061 /* Invalid or unknown country code */ #define JET_errInvalidLanguageId -1062 /* Invalid or unknown language id */ #define JET_errInvalidCodePage -1063 /* Invalid or unknown code page */ #define JET_errCantBuildKey -1064 /* Can't build key for this sort order. */ #define JET_errIllegalReentrancy -1065 /* Re-entrancy on same cursor family */ #define JET_errIllegalRelationship -1066 /* Can't create relationship */ #define JET_wrnNoWriteLock 1067 /* No write lock at transaction level 0 */ #define JET_errDBVerFeatureNotAvailable -1067 /* API not supported using old database format*/ #define JET_errCantBegin -1101 /* Cannot BeginSession */ #define JET_errWriteConflict -1102 /* Write lock failed due to outstanding write lock */ #define JET_errTransTooDeep -1103 /* Xactions nested too deeply */ #define JET_errInvalidSesid -1104 /* Invalid session handle */ #define JET_errReadConflict -1105 /* Commit lock failed due to outstanding read lock */ #define JET_errCommitConflict -1106 /* Read lock failed due to outstanding commit lock */ #define JET_errSessionWriteConflict -1107 /* Another session has private version of page */ #define JET_errInTransaction -1108 /* Operation not allowed within a transaction */ #define JET_errDatabaseDuplicate -1201 /* Database already exists */ #define JET_errDatabaseInUse -1202 /* Database in use */ #define JET_errDatabaseNotFound -1203 /* No such database */ #define JET_errDatabaseInvalidName -1204 /* Invalid database name */ #define JET_errDatabaseInvalidPages -1205 /* Invalid number of pages */ #define JET_errDatabaseCorrupted -1206 /* non-db file or corrupted db */ #define JET_errDatabaseLocked -1207 /* Database exclusively locked */ #define JET_wrnDatabaseEncrypted 1208 /* Database is encrypted */ #define JET_wrnTableEmpty 1301 /* Open an empty table */ #define JET_errTableLocked -1302 /* Table is exclusively locked */ #define JET_errTableDuplicate -1303 /* Table already exists */ #define JET_errTableInUse -1304 /* Table is in use, cannot lock */ #define JET_errObjectNotFound -1305 /* No such table or object */ #define JET_errCannotRename -1306 /* Cannot rename temporary file */ #define JET_errDensityInvalid -1307 /* Bad file/index density */ #define JET_errTableNotEmpty -1308 /* Cannot define clustered index */ #define JET_errTableNotLocked -1309 /* No DDLs w/o exclusive lock */ #define JET_errInvalidTableId -1310 /* Invalid table id */ #define JET_errTooManyOpenTables -1311 /* Cannot open any more tables */ #define JET_errIllegalOperation -1312 /* Oper. not supported on table */ #define JET_wrnExecSegReleased 1313 /* Query Execution segment is released */ #define JET_errObjectDuplicate -1314 /* Table or object name in use */ #define JET_errRulesLoaded -1315 /* Rules loaded, can't define more */ #define JET_errInvalidObject -1316 /* object is invalid for operation */ #define JET_errIndexCantBuild -1401 /* Cannot build clustered index */ #define JET_errIndexHasPrimary -1402 /* Primary index already defined */ #define JET_errIndexDuplicate -1403 /* Index is already defined */ #define JET_errIndexNotFound -1404 /* No such index */ #define JET_errIndexMustStay -1405 /* Cannot delete clustered index */ #define JET_errIndexInvalidDef -1406 /* Illegal index definition */ #define JET_errSelfReference -1407 /* Referencing/Referenced index is the same */ #define JET_errIndexHasClustered -1408 /* Clustered index already defined */ #define JET_errColumnLong -1501 /* column value is long */ #define JET_errColumnNoChunk -1502 /* no such chunk in field */ #define JET_errColumnDoesNotFit -1503 /* Field will not fit in record */ #define JET_errNullInvalid -1504 /* Null not valid */ #define JET_errColumnIndexed -1505 /* Column indexed, cannot delete */ #define JET_errColumnTooBig -1506 /* Field length is > maximum */ #define JET_errColumnNotFound -1507 /* No such column */ #define JET_errColumnDuplicate -1508 /* Field is already defined */ #define JET_errTaggedDefault -1509 /* No defaults on tagged fields */ #define JET_errColumn2ndSysMaint -1510 /* Second autoinc or version column */ #define JET_errInvalidColumnType -1511 /* Invalid column data type */ #define JET_wrnColumnMaxTruncated 1512 /* Max length too big, truncated */ #define JET_errColumnCannotIndex -1513 /* Cannot index Bit,LongText,LongBinary */ #define JET_errTaggedNotNULL -1514 /* No non-NULL tagged fields */ #define JET_errNoCurrentIndex -1515 /* Invalid w/o a current index */ #define JET_errKeyIsMade -1516 /* The key is completely made */ #define JET_errBadColumnId -1517 /* Column Id Incorrect */ #define JET_errBadItagSequence -1518 /* Bad itagSequence for tagged column */ #define JET_errColumnInRelationship -1519 /* Cannot delete, column participates in relationship */ #define JET_wrnCopyLongValue 1520 /* Single instance column bursted */ #define JET_errCannotBeTagged -1521 /* AutoIncrement and Version cannot be tagged */ #define JET_errRecordNotFound -1601 /* The key was not found */ #define JET_errRecordNoCopy -1602 /* No working buffer */ #define JET_errNoCurrentRecord -1603 /* Currency not on a record */ #define JET_errRecordClusteredChanged -1604 /* Primary key may not change */ #define JET_errKeyDuplicate -1605 /* Illegal duplicate key */ #define JET_errCannotInsertBefore -1606 /* Cannot insert before current */ #define JET_errAlreadyPrepared -1607 /* Already copy/clear current */ #define JET_errKeyNotMade -1608 /* No call to JetMakeKey */ #define JET_errUpdateNotPrepared -1609 /* No call to JetPrepareUpdate */ #define JET_wrnDataHasChanged 1610 /* Data has changed */ #define JET_errDataHasChanged -1611 /* Data has changed; operation aborted */ #define JET_errIntegrityViolationMaster -1612 /* References to key exist */ #define JET_errIntegrityViolationSlave -1613 /* No referenced key exists */ #define JET_wrnMuchDataChanged 1614 /* Repaint whole datasheet */ #define JET_errIncorrectJoinKey -1615 /* Master key does not match lookup key */ #define JET_wrnKeyChanged 1618 /* Moved to new key */ #define JET_wrnSyncedToDelRec 1699 /* CONSIDER: QJET INTERNAL */ #define JET_errRedoPrepUpdate 1698 /* CONSIDER: QJET INTERNAL(jpbulk.c)*/ #define JET_errTooManySorts -1701 /* Too many sort processes */ #define JET_errInvalidOnSort -1702 /* Invalid operation on Sort */ #define JET_errConfigOpenError -1801 /* Config. file can't be opened */ #define JET_errSysDatabaseOpenError -1802 /* System db could not be opened */ #define JET_errTempFileOpenError -1803 /* Temp file could not be opened */ #define JET_errDatabaseOpenError -1804 /* Database file can't be opened */ #define JET_errTooManyAttachedDatabases -1805 /* Too many open databases */ #define JET_errDatabaseCloseError -1806 /* Db file could not be closed */ #define JET_errTooManyOpenFiles -1807 /* Too many files open */ #define JET_errDiskFull -1808 /* No space left on disk */ #define JET_errPermissionDenied -1809 /* Permission denied */ #define JET_errSortFileOpenError -1810 /* Could not open sort file */ #define JET_errFileNotFound -1811 /* File not found */ #define JET_errTempDiskFull -1812 /* No space left on disk */ #define JET_wrnFileOpenReadOnly 1813 /* Database file is read only */ #define JET_errAfterInitialization -1850 /* Cannot Restore after init. */ #define JET_errSeriesTooLong -1851 /* New log generation id too big */ #define JET_errLogCorrupted -1852 /* Logs could not be interpreted */ #define JET_errCannotOpenSystemDb -1901 /* failed sysdb on beginsession */ #define JET_errInvalidLogon -1902 /* invalid logon at beginsession */ #define JET_errInvalidAccountName -1903 /* invalid account name */ #define JET_errInvalidSid -1904 /* invalid SID */ #define JET_errInvalidPassword -1905 /* invalid password */ #define JET_errInvalidOperation -1906 /* invalid operation */ #define JET_errAccessDenied -1907 /* access denied */ #define JET_errNoMSysAccounts -1908 /* Can't open MSysAccounts */ #define JET_errNoMSysGroups -1909 /* Can't open MSysGroups */ #define JET_errInvalidPin -1910 /* invalid pin */ #define JET_errRmtSqlError -2001 /* RMT: ODBC call failed */ #define JET_errRmtMissingOdbcDll -2006 /* RMT: Can't load ODBC DLL */ #define JET_errRmtInsertFailed -2007 /* RMT: Insert statement failed */ #define JET_errRmtDeleteFailed -2008 /* RMT: Delete statement failed */ #define JET_errRmtUpdateFailed -2009 /* RMT: Update statement failed */ #define JET_errRmtColDataTruncated -2010 /* RMT: data truncated */ #define JET_errRmtTypeIncompat -2011 /* RMT: Can't create JET type on server */ #define JET_errRmtCreateTableFailed -2012 /* RMT: Create table stmt failed */ #define JET_errRmtNotSupported -2014 /* RMT: Function not legal for rdb */ #define JET_errRmtValueOutOfRange -2020 /* RMT: Data value out of range */ #define JET_errRmtStillExec -2021 /* RMT INTERNAL: SQL_STILL_EXECUTING */ #define JET_errRmtQueryTimeout -2022 /* RMT: Server Not Responding */ #define JET_wrnRmtNeedLvData 2023 /* RMT: Internal only - need Lv data */ #define JET_wrnFatCursorUseless 2024 /* Fat cursor has no effect ***/ #define JET_errRmtWrongSPVer -2025 /* RMT: INTERNAL: wrong SProc ver ***/ #define JET_errRmtLinkOutOfSync -2026 /* RMT: the def for the rmt tbl has changed */ #define JET_errRmtDenyWriteIsInvalid -2027 /* RMT: Can't open DenyWrite */ #define JET_errRmtDriverCantConv -2029 /* RMT: INTERNAL: driver cannot convert */ #define JET_errRmtTableAmbiguous -2030 /* RMT: Table ambiguous: must specifier owner */ #define JET_errRmtBogusConnStr -2031 /* RMT: SPT: Bad connect string */ #define JET_errQueryInvalidAttribute -3001 /* Invalid query attribute */ #define JET_errQueryOnlyOneRow -3002 /* Only 1 such row allowed */ #define JET_errQueryIncompleteRow -3003 /* Missing value in row */ #define JET_errQueryInvalidFlag -3004 /* Invalid value in Flag field */ #define JET_errQueryCycle -3005 /* Cycle in query definition */ #define JET_errQueryInvalidJoinTable -3006 /* Invalid table in join */ #define JET_errQueryAmbigRef -3007 /* Ambiguous column reference */ #define JET_errQueryUnboundRef -3008 /* Cannot bind name */ #define JET_errQueryParmRedef -3009 /* Parm redefined with different type */ #define JET_errQueryMissingParms -3010 /* Too few parameters supplied */ #define JET_errQueryInvalidOutput -3011 /* Invalid query output */ #define JET_errQueryInvalidHaving -3012 /* HAVING clause without aggregation */ #define JET_errQueryDuplicateAlias -3013 /* Duplicate output alias */ #define JET_errQueryInvalidMGBInput -3014 /* Cannot input from MGB */ #define JET_errQueryInvalidOrder -3015 /* Invalid ORDER BY expression */ #define JET_errQueryTooManyLevels -3016 /* Too many levels on MGB */ #define JET_errQueryMissingLevel -3017 /* Missing intermediate MGB level */ #define JET_errQueryIllegalAggregate -3018 /* Aggregates not allowed */ #define JET_errQueryDuplicateOutput -3019 /* Duplicate destination output */ #define JET_errQueryIsBulkOp -3020 /* Grbit should be set for Bulk Operation */ #define JET_errQueryIsNotBulkOp -3021 /* Query is not a Bulk Operation */ #define JET_errQueryIllegalOuterJoin -3022 /* No inconsistent updates on outer joins */ #define JET_errQueryNullRequired -3023 /* Column must be NULL */ #define JET_errQueryNoOutputs -3024 /* Query must have an output */ #define JET_errQueryNoInputTables -3025 /* Query must have an input */ #define JET_wrnQueryNonUpdatableRvt 3026 /* Query is not updatable (but IS RVT) */ #define JET_errQueryInvalidAlias -3027 /* Bogus character in alias name */ #define JET_errQueryInvalidBulkInput -3028 /* Cannot input from bulk operation */ #define JET_errQueryNotDirectChild -3029 /* T.* must use direct child */ #define JET_errQueryExprEvaluation -3030 /* Expression evaluation error */ #define JET_errQueryIsNotRowReturning -3031 /* Query does not return rows */ #define JET_wrnQueryNonRvt 3032 /* Can't create RVT, query is static */ #define JET_errQueryParmTypeMismatch -3033 /* Wrong parameter type given */ #define JET_errQueryChanging -3034 /* Query Objects are being updated */ #define JET_errQueryNotUpdatable -3035 /* Operation must use an updatable query */ #define JET_errQueryMissingColumnName -3036 /* Missing destination column */ #define JET_errQueryTableDuplicate -3037 /* Repeated table name in FROM list */ #define JET_errQueryIsMGB -3038 /* Query is an MGB */ #define JET_errQueryInsIntoBulkMGB -3039 /* Cannot insert into Bulk/MGB */ #define JET_errQueryDistinctNotAllowed -3040 /* DISTINCT not allowed for MGB */ #define JET_errQueryDistinctRowNotAllow -3041 /* DISTINCTROW not allowed for MGB */ #define JET_errQueryNoDbForParmDestTbl -3045 /* Dest DB for VT parm not allowed */ #define JET_errQueryDuplicatedFixedSet -3047 /* Duplicated Fixed Value */ #define JET_errQueryNoDeleteTables -3048 /* Must specify tables to delete from */ #define JET_errQueryCannotDelete -3049 /* Cannot delete from specified tables */ #define JET_errQueryTooManyGroupExprs -3050 /* Too many GROUP BY expressions */ #define JET_errQueryTooManyOrderExprs -3051 /* Too many ORDER BY expressions */ #define JET_errQueryTooManyDistExprs -3052 /* Too many DISTINCT output expressions */ #define JET_errQueryBadValueList -3053 /* Malformed value list in Transform */ #define JET_errConnStrTooLong -3054 /* Connect string too long */ #define JET_errQueryInvalidParm -3055 /* Invalid Parmeter Name (>64 char) */ #define JET_errQueryContainsDbParm -3056 /* Can't get parameters with Db Parm */ #define JET_errQueryBadUpwardRefed -3057 /* Illegally Upward ref'ed */ #define JET_errQueryAmbiguousJoins -3058 /* Joins in a QO are ambiguous */ #define JET_errQueryIsNotDDL -3059 /* Not a DDL Operation */ #define JET_errNoDbInConnStr -3060 /* No database in connect string */ #define JET_wrnQueryIsNotRowReturning 3061 /* Not row returning */ #define JET_errTooManyFindSessions -3062 /* RVT already has a find session open */ #define JET_errSingleValueExpected -3063 /* At most one record with one column can be returned from a scalar subquery */ #define JET_errColumnCountMismatch -3064 /* Union Query: number of columns in children dont match */ #define JET_errQueryTopNotAllowed -3065 /* Top not allowed for MGB */ #define JET_errQueryIsDDL -3066 /* Must set JET_bitTableDDL */ #define JET_errQueryIsCorrupt -3067 /* Query is Corrupt */ #define JET_errQuerySPTBulkSucceeded -3068 /* INTERNAL only */ #define JET_errSPTReturnedNoRecords -3069 /* SPT marked as RowReturning did not return a table */ #define JET_errExprSyntax -3100 /* Syntax error in expression */ #define JET_errExprIllegalType -3101 /* Illegal type in expression */ #define JET_errExprUnknownFunction -3102 /* Unknown function in expression */ #define JET_errSQLSyntax -3500 /* Bogus SQL statement type */ #define JET_errSQLParameterSyntax -3501 /* Parameter clause syntax error */ #define JET_errSQLInsertSyntax -3502 /* INSERT clause syntax error */ #define JET_errSQLUpdateSyntax -3503 /* UPDATE clause syntax error */ #define JET_errSQLSelectSyntax -3504 /* SELECT clause syntax error */ #define JET_errSQLDeleteSyntax -3505 /* Expected 'FROM' after 'DELETE' */ #define JET_errSQLFromSyntax -3506 /* FROM clause syntax error */ #define JET_errSQLGroupBySyntax -3507 /* GROUP BY clause syntax error */ #define JET_errSQLOrderBySyntax -3508 /* ORDER BY clause syntax error */ #define JET_errSQLLevelSyntax -3509 /* LEVEL syntax error */ #define JET_errSQLJoinSyntax -3510 /* JOIN syntax error */ #define JET_errSQLTransformSyntax -3511 /* TRANSFORM syntax error */ #define JET_errSQLHavingSyntax -3512 /* HAVING clause syntax error */ #define JET_errSQLWhereSyntax -3513 /* WHERE clause syntax error */ #define JET_errSQLProcedureSyntax -3514 /* Expected query name after 'PROCEDURE' */ #define JET_errSQLNotEnoughBuf -3515 /* Buffer too small for SQL string */ #define JET_errSQLMissingSemicolon -3516 /* Missing ; at end of SQL statement */ #define JET_errSQLTooManyTokens -3517 /* Characters after end of SQL statement */ #define JET_errSQLOwnerAccessSyntax -3518 /* OWNERACCESS OPTION syntax error */ #define JET_errV11NotSupported -3519 /* not supported in V11 */ #define JET_errV10Format -3520 /* can be present in V10 format only */ #define JET_errSQLUnionSyntax -3521 /* UNION query syntax error */ #define JET_errSqlPassThrough -3523 /* Pass Through query Disallowed */ #define JET_wrnSqlPassThrough 3524 /* Pass Through query involved */ #define JET_errDDLConstraintSyntax -3550 /* constraint syntax error */ #define JET_errDDLCreateTableSyntax -3551 /* create table syntax error */ #define JET_errDDLCreateIndexSyntax -3552 /* create index syntax error */ #define JET_errDDLColumnDefSyntax -3553 /* column def syntax error */ #define JET_errDDLAlterTableSyntax -3554 /* alter table syntax error */ #define JET_errDDLDropIndexSyntax -3555 /* drop index syntax error */ #define JET_errDDLDropSyntax -3556 /* drop view/procedure syntax error */ #define JET_errDDLCreateViewSyntax -3557 /* create view syntax error */ #define JET_errNoSuchProperty -3600 /* Property was not found */ #define JET_errPropertyTooLarge -3601 /* Small Property larger than 2K */ #define JET_errJPMInvalidForV1x -3602 /* No JPM for V1.x databases */ #define JET_errPropertyExists -3603 /* Property already exists */ #define JET_errInvalidDelete -3604 /* DeleteOnly called with non-zero cbData */ #define JET_wrnFindWrapped 3700 /* Cursor wrapped during fast find */ #define JET_errTLVNativeUserTablesOnly -3700 /* TLVs can only be placed on native user tables/columns */ #define JET_errTLVNoNull -3701 /* This field cannot be null */ #define JET_errTLVNoBlank -3702 /* This column cannot be blank */ #define JET_errTLVRuleViolation -3703 /* This validation rule must be met */ #define JET_errTLVInvalidColumn -3704 /* This TLV property cannot be placed on this column */ #define JET_errTLVExprEvaluation -3705 /* Expression evaluation error */ #define JET_errTLVExprUnknownFunc -3706 /* Unknown function in TLV expression */ #define JET_errTLVExprSyntax -3707 /* Syntax error in TLV expression */ /* CONSIDER: Remove the following error. */ #define JET_errGeneral -5001 /* I-ISAM: assert failure */ #define JET_errRecordLocked -5002 /* I-ISAM: record locked */ #define JET_wrnColumnDataTruncated 5003 /* I-ISAM: data truncated */ #define JET_errTableNotOpen -5004 /* I-ISAM: table is not open */ #define JET_errDecryptFail -5005 /* I-ISAM: incorrect password */ #define JET_wrnCurrencyLost 5007 /* I-ISAM: currency lost - must first/last */ #define JET_errDateOutOfRange -5008 /* I-ISAM: invalid date */ #define JET_wrnOptionsIgnored 5011 /* I-ISAM: options were ignored */ #define JET_errTableNotComplete -5012 /* I-ISAM: incomplete table definition */ #define JET_errIllegalNetworkOption -5013 /* I-ISAM: illegal network option */ #define JET_errIllegalTimeoutOption -5014 /* I-ISAM: illegal timeout option */ #define JET_errNotExternalFormat -5015 /* I-ISAM: invalid file format */ #define JET_errUnexpectedEngineReturn -5016 /* I-ISAM: unexpected engine error code */ #define JET_errNumericFieldOverflow -5017 /* I-ISAM: can't convert to native type */ #define JET_errIndexHasNoPrimary -5020 /* Paradox: no primary index */ #define JET_errTableSortOrderMismatch -5021 /* Paradox: sort order mismatch */ #define JET_errNoConfigParameters -5023 /* Paradox: net path or user name missing */ #define JET_errCantAccessParadoxNetDir -5024 /* Paradox: bad Paradox net path */ #define JET_errObsoleteLockFile -5025 /* Paradox: obsolete lock file */ #define JET_errIllegalCollatingSequence -5026 /* Paradox: invalid sort sequence */ #define JET_errWrongCollatingSequence -5027 /* Paradox: wrong sort sequence */ #define JET_errCantUseUnkeyedTable -5028 /* Paradox: can't open unkeyed table */ #define JET_errINFFileError -5101 /* dBase: invalid .INF file */ #define JET_errCantMakeINFFile -5102 /* dBase: can't open .INF file */ #define JET_wrnCantMaintainIndex 5103 /* dBase: unmaintainable index */ #define JET_errMissingMemoFile -5104 /* dBase: missing memo file */ #define JET_errIllegalCenturyOption -5105 /* dBase: Illegal century option */ #define JET_errIllegalDeletedOption -5106 /* dBase: Illegal deleted option */ #define JET_errIllegalStatsOption -5107 /* dBase: Illegal statistics option */ #define JET_errIllegalDateOption -5108 /* dBase: Illegal date option */ #define JET_errIllegalMarkOption -5109 /* dBase: Illegal mark option */ #define JET_wrnDuplicateIndexes 5110 /* dBase: duplicate indexes in INF file */ #define JET_errINFIndexNotFound -5111 /* dBase: missing index in INF file */ #define JET_errWrongMemoFileType -5112 /* dBase: wrong memo file type */ #define JET_errIllegalExactOption -5113 /* dBase: Illegal exact option */ #define JET_errTooManyLongFields -5200 /* Btrieve: more than one memo field */ #define JET_errCantStartBtrieve -5201 /* Btrieve: wbtrcall.dll missing */ #define JET_errBadConfigParameters -5202 /* Btrieve: win.ini [btrieve] options wrong */ #define JET_errIndexesChanged -5203 /* Btrieve: need to GetIndexInfo */ #define JET_errNonModifiableKey -5204 /* Btrieve: can't modify record column */ #define JET_errOutOfBVResources -5205 /* Btrieve: out of resources */ #define JET_errBtrieveDeadlock -5206 /* Btrieve: locking deadlock */ #define JET_errBtrieveFailure -5207 /* Btrieve: Btrieve DLL failure */ #define JET_errBtrieveDDCorrupted -5208 /* Btrieve: data dictionary corrupted */ #define JET_errBtrieveTooManyTasks -5209 /* Btrieve: too many tasks */ #define JET_errIllegalIndexDDFOption -5210 /* Btrieve: Illegal IndexDDF option */ #define JET_errIllegalDataCodePage -5211 /* Btrieve: Illeagl DataCodePage option */ #define JET_errXtrieveEnvironmentError -5212 /* Btrieve: Xtrieve INI options bad */ #define JET_errMissingDDFFile -5213 /* Btrieve: Missing field.ddf */ #define JET_errIlleaglIndexNumberOption -5214 /* Btrieve: Illeagl IndexRenumber option */ /* Extended error codes must be in the following range. */ /* Major error codes may not be in this range. */ #define JET_errMinorLeast -8000 #define JET_errMinorMost -8999 #define JET_errFindExprSyntax -8001 /* Syntax error in FastFind expression */ #define JET_errQbeExprSyntax -8002 /* Syntax error in QBE expression */ #define JET_errInputTableNotFound -8003 /* Non-existant object in FROM list */ #define JET_errQueryExprSyntax -8004 /* Syntax error in some query expression */ #define JET_errQodefExprSyntax -8005 /* Syntax error in expression column */ #define JET_errExpAliasAfterAS -8006 /* Expected alias after 'AS' in FROM list */ #define JET_errExpBYAfterGROUP -8007 /* Expected 'BY' after 'GROUP' */ #define JET_errExpBYAfterORDER -8008 /* Expected 'BY' after 'ORDER' */ #define JET_errExpClsParenAfterColList -8009 /* Expected ')' after column list */ #define JET_errExpColNameAfterPIVOT -8010 /* Expected column name after 'PIVOT' */ #define JET_errExpDatabaseAfterIN -8011 /* Expected database name after 'IN' */ #define JET_errExpDatatypeAfterParmName -8012 /* Expected datatype after parameter name */ #define JET_errExpEqualAfterUpdColName -8013 /* Expected '=' after update column name */ #define JET_errExpExprAfterON -8014 /* Expected join expression after 'ON' */ #define JET_errExpExprAfterTRANSFORM -8015 /* Expected expression after 'TRANSFORM' */ #define JET_errExpExprAfterWHERE -8016 /* Expected expression after 'WHERE' */ #define JET_errExpGroupClauseInXform -8017 /* Transform expects GROUP BY clause */ #define JET_errExpGroupingExpr -8018 /* Expected grouping expression */ #define JET_errExpHavingExpr -8019 /* Expected HAVING expression */ #define JET_errExpINTOAfterINSERT -8020 /* Expected 'INTO' after 'INSERT' */ #define JET_errExpJOINAfterJoinType -8021 /* Expected 'JOIN' after INNER/LEFT/RIGHT */ #define JET_errExpLEVELAfterSelectList -8022 /* Expected LEVEL after select list */ #define JET_errExpNumberAfterLEVEL -8023 /* Expected number after 'LEVEL' */ #define JET_errExpONAfterRightTable -8024 /* Expected 'ON' after right join table */ #define JET_errExpOrderExpr -8025 /* Expected ordering expression */ #define JET_errExpOutputAliasAfterAS -8026 /* Expected output alias after 'AS' */ #define JET_errExpOutputExpr -8027 /* Expected output expression */ #define JET_errExpPIVOTAfterSelectStmt -8028 /* Expected 'PIVOT' after SELECT statement */ #define JET_errExpRightJoinTable -8029 /* Expected right join table after 'JOIN' */ #define JET_errExpSELECTAfterInsClause -8030 /* Expected 'SELECT' after INSERT clause */ #define JET_errExpSELECTAfterXformExpr -8031 /* Expected 'SELECT' after Transform fact */ #define JET_errExpSETAfterTableName -8032 /* Expected 'SET' after table name */ #define JET_errExpSemiAfterLevelNumber -8033 /* Expected ';' after level number */ #define JET_errExpSemiAfterParmList -8034 /* Expected ';' after parmeter list */ #define JET_errExpSemiAfterPivotClause -8035 /* Expected ';' after PIVOT clause */ #define JET_errExpSemiAtEndOfSQL -8036 /* Expected ';' at end of SQL statement */ #define JET_errExpTableName -8037 /* Expected table name */ #define JET_errExpTableNameAfterINTO -8038 /* Expected table name after 'INTO' */ #define JET_errExpUpdExprAfterEqual -8039 /* Expected update expression after '=' */ #define JET_errExpUpdateColName -8040 /* Expected update column name */ #define JET_errInvTokenAfterFromList -8041 /* Bogus token after FROM list */ #define JET_errInvTokenAfterGroupList -8042 /* Bogus token after GROUP BY list */ #define JET_errInvTokenAfterHavingCls -8043 /* Bogus token after HAVING clause */ #define JET_errInvTokenAfterOrderClause -8044 /* Bogus token after ORDER BY clause */ #define JET_errInvTokenAfterSelectCls -8045 /* Bogus token after SELECT clause */ #define JET_errInvTokenAfterWhereClause -8046 /* Bogus token after WHERE clause */ #define JET_errLevelNumberTooBig -8047 /* Number after 'LEVEL' too big */ #define JET_errLevelOnNonMGB -8048 /* LEVEL allowed only in MGB */ #define JET_errIllegalDetailReference -8049 /* Not group key or agg, but not MGB detail */ #define JET_errAggOverMixedLevels -8050 /* Agg. arg. uses outputs from > 1 level */ #define JET_errAggregatingHigherLevel -8051 /* Agg. over output of same/higher level */ #define JET_errNullInJoinKey -8052 /* Cannot set column in join key to NULL */ #define JET_errValueBreaksJoin -8053 /* Join is broken by column value(s) */ #define JET_errInsertIntoUnknownColumn -8054 /* INSERT INTO unknown column name */ #define JET_errNoSelectIntoColumnName -8055 /* No dest. col. name in SELECT INTO stmt */ #define JET_errNoInsertColumnName -8056 /* No dest. col. name in INSERT stmt */ #define JET_errColumnNotInJoinTable -8057 /* Join expr refers to non-join table */ #define JET_errAggregateInJoin -8058 /* Aggregate in JOIN clause */ #define JET_errAggregateInWhere -8059 /* Aggregate in WHERE clause */ #define JET_errAggregateInOrderBy -8060 /* Aggregate in ORDER BY clause */ #define JET_errAggregateInGroupBy -8061 /* Aggregate in GROUP BY clause */ #define JET_errAggregateInArgument -8062 /* Aggregate in argument expression */ #define JET_errHavingOnTransform -8063 /* HAVING clause on TRANSFORM query */ #define JET_errHavingWithoutGrouping -8064 /* HAVING clause w/o grouping/aggregation */ #define JET_errHavingOnMGB -8065 /* HAVING clause on MGB query */ #define JET_errOutputAliasCycle -8066 /* Cycle in SELECT list (via aliases) */ #define JET_errDotStarWithGrouping -8067 /* 'T.*' with grouping, but not MGB level 0 */ #define JET_errStarWithGrouping -8068 /* '*' with grouping, but not MGB detail */ #define JET_errQueryTreeCycle -8069 /* Cycle in tree of query objects */ #define JET_errTableRepeatInFromList -8072 /* Table appears twice in FROM list */ #define JET_errTooManyXformLevels -8073 /* Level > 2 in TRANSFORM query */ #define JET_errTooManyMGBLevels -8074 /* Too many levels in MGB */ #define JET_errNoUpdateColumnName -8075 /* No dest. column name in UPDATE stmt */ #define JET_errJoinTableNotInput -8076 /* Join table not in FROM list */ #define JET_errUnaliasedSelfJoin -8077 /* Join tables have same name */ #define JET_errOutputLevelTooBig -8078 /* Output w/ level > 1+max group level */ #define JET_errOrderVsGroup -8079 /* ORDER BY conflicts with GROUP BY */ #define JET_errOrderVsDistinct -8080 /* ORDER BY conflicts with DISTINCT */ #define JET_errExpLeftParenthesis -8082 /* Expected '(' */ #define JET_errExpRightParenthesis -8083 /* Expected ')' */ #define JET_errEvalEBESErr -8084 /* EB/ES error evaluating expression */ #define JET_errQueryExpCloseQuote -8085 /* Unmatched quote for database name */ #define JET_errQueryParmNotDatabase -8086 /* Parameter type should be database */ #define JET_errQueryParmNotTableid -8087 /* Parameter type should be tableid */ #define JET_errExpIdentifierM -8088 /* Expected identifier */ #define JET_errExpQueryName -8089 /* Expected query name after PROCEDURE */ #define JET_errExprUnknownFunctionM -8090 /* Unknown function in expression */ #define JET_errQueryAmbigRefM -8091 /* Ambiguous column reference */ #define JET_errQueryBadBracketing -8092 /* Bad bracketing of identifier */ #define JET_errQueryBadQodefName -8093 /* Invalid name in QODEF row */ #define JET_errQueryBulkColNotUpd -8094 /* Column not updatable (bulk op) */ #define JET_errQueryDistinctNotAllowedM -8095 /* DISTINCT not allowed for MGB */ #define JET_errQueryDuplicateAliasM -8096 /* Duplicate output alias */ #define JET_errQueryDuplicateOutputM -8097 /* Duplicate destination output */ #define JET_errQueryDuplicatedFixedSetM -8098 /* Duplicated Fixed Value */ #define JET_errQueryIllegalOuterJoinM -8099 /* No inconsistent updates on outer joins */ #define JET_errQueryIncompleteRowM -8100 /* Missing value in row */ #define JET_errQueryInvalidAttributeM -8101 /* Invalid query attribute */ #define JET_errQueryInvalidBulkInputM -8102 /* Cannot input from bulk operation */ #define JET_errQueryInvalidFlagM -8103 /* Invalid value in Flag field */ #define JET_errQueryInvalidMGBInputM -8104 /* Cannot input from MGB */ #define JET_errQueryLVInAggregate -8105 /* Illegal long value in aggregate */ #define JET_errQueryLVInDistinct -8106 /* Illegal long value in DISTINCT */ #define JET_errQueryLVInGroupBy -8107 /* Illegal long value in GROUP BY */ #define JET_errQueryLVInHaving -8108 /* Illegal long value in HAVING */ #define JET_errQueryLVInJoin -8109 /* Illegal long value in JOIN */ #define JET_errQueryLVInOrderBy -8110 /* Illegal long value in ORDER BY */ #define JET_errQueryMissingLevelM -8111 /* Missing intermediate MGB level */ #define JET_errQueryMissingParmsM -8112 /* Too few parameters supplied */ #define JET_errQueryNoDbForParmDestTblM -8113 /* Dest DB for VT parm not allowed */ #define JET_errQueryNoDeletePerm -8114 /* No delete permission on table/query */ #define JET_errQueryNoInputTablesM -8115 /* Query must have an input */ #define JET_errQueryNoInsertPerm -8116 /* No insert permission on table/query */ #define JET_errQueryNoOutputsM -8117 /* Query must have an output */ #define JET_errQueryNoReadDefPerm -8118 /* No permission to read query definition */ #define JET_errQueryNoReadPerm -8119 /* No read permission on table/query */ #define JET_errQueryNoReplacePerm -8120 /* No replace permission on table/query */ #define JET_errQueryNoTblCrtPerm -8121 /* No CreateTable permission (bulk op) */ #define JET_errQueryNotDirectChildM -8122 /* T.* must use direct child */ #define JET_errQueryNullRequiredM -8123 /* Column must be NULL */ #define JET_errQueryOnlyOneRowM -8124 /* Only 1 such row allowed */ #define JET_errQueryOutputColNotUpd -8125 /* Query output column not updatable */ #define JET_errQueryParmRedefM -8126 /* Parm redefined with different type */ #define JET_errQueryParmTypeMismatchM -8127 /* Wrong parameter type given */ #define JET_errQueryUnboundRefM -8128 /* Cannot bind name */ #define JET_errRmtConnectFailedM -8129 /* RMT: Connection attempt failed */ #define JET_errRmtDeleteFailedM -8130 /* RMT: Delete statement failed */ #define JET_errRmtInsertFailedM -8131 /* RMT: Insert statement failed */ #define JET_errRmtMissingOdbcDllM -8132 /* RMT: Can't load ODBC DLL */ #define JET_errRmtSqlErrorM -8133 /* RMT: ODBC call failed */ #define JET_errRmtUpdateFailedM -8134 /* RMT: Update statement failed */ #define JET_errSQLDeleteSyntaxM -8135 /* Expected 'FROM' after 'DELETE' */ #define JET_errSQLSyntaxM -8136 /* Bogus SQL statement type */ #define JET_errSQLTooManyTokensM -8137 /* Characters after end of SQL statement */ #define JET_errStarNotAtLevel0 -8138 /* '*' illegal above level 0 */ #define JET_errQueryParmTypeNotAllowed -8139 /* Parameter type not allowed for expression */ #define JET_errQueryTooManyDestColumn -8142 /* Too many destination column sepcified */ #define JET_errSQLNoInsertColumnName -8143 /* No dest. col. name in INSERT stmt */ #define JET_errRmtLinkNotFound -8144 /* RMT: link not found */ #define JET_errRmtTooManyColumns -8145 /* RMT: Too many columns on Select Into */ #define JET_errWriteConflictM -8146 /* Write lock failed due to outstanding write lock */ #define JET_errReadConflictM -8147 /* Commit lock failed due to outstanding read lock */ #define JET_errCommitConflictM -8148 /* Read lock failed due to outstanding commit lock */ #define JET_errTableLockedM -8149 /* Table is exclusively locked */ #define JET_errTableInUseM -8150 /* Table is in use, cannot lock */ #define JET_errQueryTooManyXvtColumn -8151 /* Too many cross table column headers */ #define JET_errOutputTableNotFound -8152 /* Non-existent table in Insert Into */ #define JET_errTableLockedQM -8153 /* Table is exclusively locked */ #define JET_errTableInUseQM -8154 /* Table is in use, cannot lock */ #define JET_errTableLockedMUQM -8155 /* Table is exclusively locked */ #define JET_errTableInUseMUQM -8156 /* Table is in use, cannot lock */ #define JET_errQueryInvalidParmM -8157 /* Invalid Parmeter Name (>64 char) */ #define JET_errFileNotFoundM -8158 /* File not found */ #define JET_errFileShareViolationM -8159 /* File sharing violation */ #define JET_errFileAccessDeniedM -8160 /* Access denied */ #define JET_errInvalidPathM -8161 /* Invalid Path */ #define JET_errTableDuplicateM -8162 /* Table already exists */ #define JET_errQueryBadUpwardRefedM -8163 /* Illegally Upward ref'ed */ #define JET_errIntegrityViolMasterM -8164 /* References to key exist */ #define JET_errIntegrityViolSlaveM -8165 /* No referenced key exists */ #define JET_errSQLUnexpectedWithM -8166 /* Unexpected 'with' in this place */ #define JET_errSQLOwnerAccessM -8167 /* Owner Access Option is defined Twice */ #define JET_errSQLOwnerAccessSyntaxM -8168 /* Owner Access Option Syntax Error */ #define JET_errSQLOwnerAccessDef -8169 /* Owner Access Option is defined more than once */ #define JET_errAccessDeniedM -8170 /* Generic Access Denied */ #define JET_errUnexpectedEngineReturnM -8171 /* I-ISAM: unexpected engine error code */ #define JET_errQueryTopNotAllowedM -8172 /* Top not allowed for MGB */ #define JET_errInvTokenAfterTableCls -8173 /* Bogus token after table clause */ #define JET_errInvTokenAfterRParen -8174 /* Unexpected tokens after a closing paren */ #define JET_errQueryBadValueListM -8175 /* Malformed value list in Transform */ #define JET_errQueryIsCorruptM -8176 /* Query is Corrupt */ #define JET_errInvalidTopArgumentM -8177 /* Select Top argument is invalid */ #define JET_errQueryIsSnapshot -8178 /* Query is a snapshot */ #define JET_errQueryExprOutput -8179 /* Output is a calculated column */ #define JET_errQueryTableRO -8180 /* Column comes from read-only table */ #define JET_errQueryRowDeleted -8181 /* Column comes from deleted row */ #define JET_errQueryRowLocked -8182 /* Column comes from locked row */ #define JET_errQueryFixupChanged -8183 /* Would row-fixup away from pending changes */ #define JET_errQueryCantFillIn -8184 /* Fill-in-the-blank only on most-many */ #define JET_errQueryWouldOrphan -8185 /* Would orphan joined records */ #define JET_errIncorrectJoinKeyM -8186 /* Must match join key in lookup table */ #define JET_errQueryLVInSubqueryM -8187 /* Illegal long value in subquery */ #define JET_errInvalidDatabaseM -8188 /* Unrecognized database format */ #define JET_errOrderVsUnion -8189 /* You can only order by an outputted column in a union */ #define JET_errTLVCouldNotBindRef -8190 /* Unknown token in TLV expression */ #define JET_errCouldNotBindRef -8191 /* Unknown token in FastFind expression */ #define JET_errQueryPKeyNotOutput -8192 /* Primary key not output */ #define JET_errQueryJKeyNotOutput -8193 /* Join key not output */ #define JET_errExclusiveDBConflict -8194 /* Conflict with exclusive user */ #define JET_errQueryNoJoinedRecord -8195 /* No F.I.T.B. insert if no joined record */ #define JET_errQueryLVInSetOp -8196 /* Illegal long value in set operation */ #define JET_errTLVExprUnknownFunctionM -8197 /* Unknown function in TLV expression */ #define JET_errInvalidNameM -8198 /* Invalid name */ #define JET_errDDLExpColName -8200 /* expect column name */ #define JET_errDDLExpLP -8201 /* expect '(' */ #define JET_errDDLExpRP -8202 /* expect ')' */ #define JET_errDDLExpIndex -8203 /* expect INDEX */ #define JET_errDDLExpIndexName -8204 /* expect index name */ #define JET_errDDLExpOn -8205 /* expect ON */ #define JET_errDDLExpKey -8206 /* expect KEY */ #define JET_errDDLExpReferences -8207 /* expect REFERENCES */ #define JET_errDDLExpTableName -8208 /* expect table name */ #define JET_errDDLExpFullOrPartial -8209 /* expect FULL or PARTIAL */ #define JET_errDDLExpCascadeOrSet -8210 /* expect CASCADE or SET */ #define JET_errDDLExpNull -8211 /* expect NULL */ #define JET_errDDLExpUpdateOrDelete -8212 /* expect UPDATE or DELETE */ #define JET_errDDLExpConstraintName -8213 /* expect constraint name */ #define JET_errDDLExpForeign -8214 /* expect FOREIGN */ #define JET_errDDLExpDatatype -8215 /* expect data type */ #define JET_errDDLExpIndexOpt -8216 /* expect index options */ #define JET_errDDLExpWith -8217 /* expect WITH */ #define JET_errDDLExpTable -8218 /* expect TABLE */ #define JET_errDDLExpEos -8219 /* expect End Of String */ #define JET_errDDLExpAddOrDrop -8220 /* expect ADD or Drop */ #define JET_errDDLCreateView -8221 /* Create view not supported */ #define JET_errDDLCreateProc -8222 /* Create proc not supported */ #define JET_errDDLExpObjectName -8223 /* expect object name */ #define JET_errDDLExpColumn -8224 /* expect COLUMN */ #define JET_errV11TableNameNotInScope -8250 /* referenced table not in join clause */ #define JET_errV11OnlyTwoTables -8251 /* exactly two tables should be referenced in join */ #define JET_errV11OneSided -8252 /* all tables come from one side of input */ #define JET_errV11Ambiguous -8253 /* Join clause is ambiguous when stored in V1 format */ #define JET_errTLVExprSyntaxM -8260 /* Syntax error in TLV expression */ #define JET_errTLVNoNullM -8261 /* This field cannot be null */ #define JET_errTLVNoBlankM -8262 /* This column cannot be blank */ #define JET_errTLVRuleViolationM -8263 /* This validation rule must be met */ #define JET_errDDLCreateViewSyntaxM -8264 /* create view syntax error */ /*********************** The following error code ranges are reserved for external use. As is true for Jet error codes, these ranges cover the negative as well as positive form of the numbers in the range. 30000 through 30999 for use by Vt Object as defined in jeteb.h 32000 through 32767 for use by Import/Export as defined in jetutil.h ***********************/ /**********************************************************************/ /*********************** PROTOTYPES **************************/ /**********************************************************************/ #if !defined(_JET_NOPROTOTYPES) /**************************************************************************** ISAM API *****************************************************************************/ JET_ERR JET_API JetInit(JET_INSTANCE _far *pinstance); JET_ERR JET_API JetTerm(JET_INSTANCE instance); JET_ERR JET_API JetSetSystemParameter(JET_INSTANCE _far *pinstance, JET_SESID sesid, unsigned long paramid, unsigned long lParam, const char _far *sz); JET_ERR JET_API JetGetSystemParameter(JET_INSTANCE instance, JET_SESID sesid, unsigned long paramid, unsigned long _far *plParam, char _far *sz, unsigned long cbMax); JET_ERR JET_API JetGetLastErrorInfo(JET_SESID sesid, JET_EXTERR _far *pexterr, unsigned long cbexterrMax, char _far *sz1, unsigned long cch1Max, char _far *sz2, unsigned long cch2Max, char _far *sz3, unsigned long cch3Max, unsigned long _far *pcch3Actual); JET_ERR JET_API JetBeginSession(JET_INSTANCE instance, JET_SESID _far *psesid, const char _far *szUserName, const char _far *szPassword); JET_ERR JET_API JetDupSession(JET_SESID sesid, JET_SESID _far *psesid); JET_ERR JET_API JetEndSession(JET_SESID sesid, JET_GRBIT grbit); JET_ERR JET_API JetGetVersion(JET_SESID sesid, unsigned long _far *pwVersion); JET_ERR JET_API JetIdle(JET_SESID sesid, JET_GRBIT grbit); JET_ERR JET_API JetCapability(JET_SESID sesid, JET_DBID dbid, unsigned long lArea, unsigned long lFunction, JET_GRBIT _far *pgrbit); JET_ERR JET_API JetCreateDatabase(JET_SESID sesid, const char _far *szFilename, const char _far *szConnect, JET_DBID _far *pdbid, JET_GRBIT grbit); JET_ERR JET_API JetAttachDatabase(JET_SESID sesid, const char _far *szFilename, JET_GRBIT grbit ); JET_ERR JET_API JetDetachDatabase(JET_SESID sesid, const char _far *szFilename); JET_ERR JET_API JetCreateTable(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, unsigned long lPages, unsigned long lDensity, JET_TABLEID _far *ptableid); JET_ERR JET_API JetRenameTable(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, const char _far *szTableNew); JET_ERR JET_API JetDeleteTable(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName); JET_ERR JET_API JetGetTableColumnInfo(JET_SESID sesid, JET_TABLEID tableid, const char _far *szColumnName, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetGetColumnInfo(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, const char _far *szColumnName, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetAddColumn(JET_SESID sesid, JET_TABLEID tableid, const char _far *szColumn, const JET_COLUMNDEF _far *pcolumndef, const void _far *pvDefault, unsigned long cbDefault, JET_COLUMNID _far *pcolumnid); JET_ERR JET_API JetRenameColumn(JET_SESID sesid, JET_TABLEID tableid, const char _far *szColumn, const char _far *szColumnNew); JET_ERR JET_API JetDeleteColumn(JET_SESID sesid, JET_TABLEID tableid, const char _far *szColumn); JET_ERR JET_API JetGetTableIndexInfo(JET_SESID sesid, JET_TABLEID tableid, const char _far *szIndexName, void _far *pvResult, unsigned long cbResult, unsigned long InfoLevel); JET_ERR JET_API JetGetTableReferenceInfo(JET_SESID sesid, JET_TABLEID tableid, const char _far *szReferenceName, void _far *pvResult, unsigned long cbResult, unsigned long InfoLevel); JET_ERR JET_API JetGetTableInfo(JET_SESID sesid, JET_TABLEID tableid, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetGetIndexInfo(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, const char _far *szIndexName, void _far *pvResult, unsigned long cbResult, unsigned long InfoLevel); JET_ERR JET_API JetGetReferenceInfo(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, const char _far *szReference, void _far *pvResult, unsigned long cbResult, unsigned long InfoLevel); JET_ERR JET_API JetCreateIndex(JET_SESID sesid, JET_TABLEID tableid, const char _far *szIndexName, JET_GRBIT grbit, const char _far *szKey, unsigned long cbKey, unsigned long lDensity); JET_ERR JET_API JetRenameIndex(JET_SESID sesid, JET_TABLEID tableid, const char _far *szIndex, const char _far *szIndexNew); JET_ERR JET_API JetDeleteIndex(JET_SESID sesid, JET_TABLEID tableid, const char _far *szIndexName); JET_ERR JET_API JetCreateReference(JET_SESID sesid, JET_TABLEID tableid, const char _far *szReferenceName, const char _far *szColumns, const char _far *szReferencedTable, const char _far *szReferencedColumns, JET_GRBIT grbit); JET_ERR JET_API JetRenameReference(JET_SESID sesid, JET_TABLEID tableid, const char _far *szReference, const char _far *szReferenceNew); JET_ERR JET_API JetDeleteReference(JET_SESID sesid, JET_TABLEID tableid, const char _far *szReferenceName); JET_ERR JET_API JetGetObjectInfo(JET_SESID sesid, JET_DBID dbid, JET_OBJTYP objtyp, const char _far *szContainerName, const char _far *szObjectName, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetCreateObject(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, JET_OBJTYP objtyp); JET_ERR JET_API JetDeleteObject(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName); JET_ERR JET_API JetRenameObject(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, const char _far *szObjectNew); JET_ERR JET_API JetBeginTransaction(JET_SESID sesid); JET_ERR JET_API JetCommitTransaction(JET_SESID sesid, JET_GRBIT grbit); JET_ERR JET_API JetRollback(JET_SESID sesid, JET_GRBIT grbit); JET_ERR JET_API JetUpdateUserFunctions(JET_SESID sesid); JET_ERR JET_API JetGetDatabaseInfo(JET_SESID sesid, JET_DBID dbid, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetCloseDatabase(JET_SESID sesid, JET_DBID dbid, JET_GRBIT grbit); JET_ERR JET_API JetCloseTable(JET_SESID sesid, JET_TABLEID tableid); JET_ERR JET_API JetOpenDatabase(JET_SESID sesid, const char _far *szFilename, const char _far *szConnect, JET_DBID _far *pdbid, JET_GRBIT grbit); JET_ERR JET_API JetOpenTable(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, const void _far *pvParameters, unsigned long cbParameters, JET_GRBIT grbit, JET_TABLEID _far *ptableid); JET_ERR JET_API JetDelete(JET_SESID sesid, JET_TABLEID tableid); JET_ERR JET_API JetUpdate(JET_SESID sesid, JET_TABLEID tableid, void _far *pvBookmark, unsigned long cbBookmark, unsigned long _far *pcbActual); JET_ERR JET_API JetRetrieveColumn(JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, void _far *pvData, unsigned long cbData, unsigned long _far *pcbActual, JET_GRBIT grbit, JET_RETINFO _far *pretinfo); JET_ERR JET_API JetRetrieveColumns( JET_SESID sesid, JET_TABLEID tableid, JET_RETRIEVECOLUMN *pretrievecolumn, unsigned long cretrievecolumn ); JET_ERR JET_API JetSetColumn(JET_SESID sesid, JET_TABLEID tableid, JET_COLUMNID columnid, const void _far *pvData, unsigned long cbData, JET_GRBIT grbit, JET_SETINFO _far *psetinfo); JET_ERR JET_API JetSetColumns(JET_SESID sesid, JET_TABLEID tableid, JET_SETCOLUMN *psetcolumn, unsigned long csetcolumn ); JET_ERR JET_API JetPrepareUpdate(JET_SESID sesid, JET_TABLEID tableid, unsigned long prep); JET_ERR JET_API JetGetRecordPosition(JET_SESID sesid, JET_TABLEID tableid, JET_RECPOS _far *precpos, unsigned long cbRecpos); JET_ERR JET_API JetGotoPosition(JET_SESID sesid, JET_TABLEID tableid, JET_RECPOS *precpos ); JET_ERR JET_API JetGetCursorInfo(JET_SESID sesid, JET_TABLEID tableid, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetDupCursor(JET_SESID sesid, JET_TABLEID tableid, JET_TABLEID _far *ptableid, JET_GRBIT grbit); JET_ERR JET_API JetGetCurrentIndex(JET_SESID sesid, JET_TABLEID tableid, char _far *szIndexName, unsigned long cchIndexName); JET_ERR JET_API JetSetCurrentIndex(JET_SESID sesid, JET_TABLEID tableid, const char _far *szIndexName); JET_ERR JET_API JetMove(JET_SESID sesid, JET_TABLEID tableid, long cRow, JET_GRBIT grbit); JET_ERR JET_API JetMakeKey(JET_SESID sesid, JET_TABLEID tableid, const void _far *pvData, unsigned long cbData, JET_GRBIT grbit); JET_ERR JET_API JetSeek(JET_SESID sesid, JET_TABLEID tableid, JET_GRBIT grbit); JET_ERR JET_API JetFastFind(JET_SESID sesid, JET_DBID dbid, JET_TABLEID tableid, const char _far *szExpr, JET_GRBIT grbit, signed long _far *pcrow); JET_ERR JET_API JetFastFindBegin(JET_SESID sesid, JET_DBID dbid, JET_TABLEID tableid, const char _far *szExpr, JET_GRBIT grbit); JET_ERR JET_API JetFastFindEnd(JET_SESID sesid, JET_TABLEID tableid); JET_ERR JET_API JetGetBookmark(JET_SESID sesid, JET_TABLEID tableid, void _far *pvBookmark, unsigned long cbMax, unsigned long _far *pcbActual); JET_ERR JET_API JetRefreshLink(JET_SESID sesid, JET_DBID dbid, const char _far *szLinkName, const char _far *szConnect, const char _far *szDatabase); #ifdef _MSC_VER /* CONSIDER: CSL doesn't like this */ JET_ERR JET_API JetRepairDatabase(JET_SESID sesid, const char _far *lszDbFile, JET_PFNSTATUS pfnstatus); #endif /* _MSC_VER */ JET_ERR JET_API JetCompact(JET_SESID sesid, const char _far *szDatabaseSrc, const char _far *szConnectSrc, const char _far *szDatabaseDest, const char _far *szConnectDest, JET_PFNSTATUS pfnStatus, JET_GRBIT grbit); JET_ERR JET_API JetGotoBookmark(JET_SESID sesid, JET_TABLEID tableid, void _far *pvBookmark, unsigned long cbBookmark); JET_ERR JET_API JetComputeStats(JET_SESID sesid, JET_TABLEID tableid); JET_ERR JET_API JetCreateRelationship(JET_SESID sesid,JET_DBID dbidIn, const char _far *szRelationshipName, const char _far *szObjectName, const char _far *szColumns, const char _far *szReferencedObject, const char _far *szReferncedColumns, char _far *szLongName, unsigned long cbMax, unsigned long _far *pcbActual, JET_GRBIT grbit); JET_ERR JET_API JetDeleteRelationship(JET_SESID sesid, JET_DBID dbidIn, const char _far *szName); JET_ERR JET_API JetGetRelationshipInfo(JET_SESID sesid, JET_DBID dbid, const char _far *szTableName, const char _far *szRelationship, void _far *pvResult, unsigned long cbResult); /***************************************************************************** SEC API *****************************************************************************/ JET_ERR JET_API JetGetSidFromName(JET_SESID sesid, const char _far *szName, void _far *pvSid, unsigned long cbMax, unsigned long _far *pcbActual, long _far *pfGroup); JET_ERR JET_API JetGetNameFromSid(JET_SESID sesid, const void _far *pvSid, unsigned long cbSid, char _far *szName, unsigned long cchName, long _far *pfGroup); JET_ERR JET_API JetCreateUser(JET_SESID sesid, const char _far *szUser, const char _far *szPassword, const char _far *szPin); JET_ERR JET_API JetChangeUserPassword(JET_SESID sesid, const char _far *szUser, const char _far *szOldPassword, const char _far *szNewPassword); JET_ERR JET_API JetDeleteUser(JET_SESID sesid, const char _far *szUser); JET_ERR JET_API JetCreateGroup(JET_SESID sesid, const char _far *szGroup, const char _far *szPin); JET_ERR JET_API JetAddMember(JET_SESID sesid, const char _far *szGroup, const char _far *szUser); JET_ERR JET_API JetRemoveMember(JET_SESID sesid, const char _far *szGroup, const char _far *szUser); JET_ERR JET_API JetDeleteGroup(JET_SESID sesid, const char _far *szGroup); JET_ERR JET_API JetSetAccess(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, const char _far *szName, JET_ACM acm, JET_GRBIT grbit); JET_ERR JET_API JetGetAccess(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, const char _far *szName, long fIndividual, JET_ACM _far *pacm, JET_GRBIT _far *pgrbit); JET_ERR JET_API JetValidateAccess(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, JET_ACM acmRequired); JET_ERR JET_API JetSetOwner(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, const char _far *szName); JET_ERR JET_API JetGetOwner(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, char _far *szName, unsigned long cchMax); /***************************************************************************** Property Management API *****************************************************************************/ JET_ERR JET_API JetSetProperty(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, const char _far *szSubObjectName, const char _far *szPropertyName, void _far *pvData, unsigned long cbData, JET_COLTYP coltyp, JET_GRBIT grbit); JET_ERR JET_API JetRetrieveProperty(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, const char _far *szSubObjectName, const char _far *szPropertyName, void _far *pvData, unsigned long cbData, unsigned long _far *pcbActual, JET_COLTYP _far *pcoltyp, JET_GRBIT grbit, unsigned long InfoLevel); JET_ERR JET_API JetSetTableProperty(JET_SESID sesid, JET_TABLEID tableid, const char _far *szSubObjectName, const char _far *szPropertyName, void _far *pvData, unsigned long cbData, JET_COLTYP coltyp, JET_GRBIT grbit); JET_ERR JET_API JetRetrieveTableProperty(JET_SESID sesid, JET_TABLEID tableid, const char _far *szSubObjectName, const char _far *szPropertyName, void _far *pvData, unsigned long cbData, unsigned long _far *pcbActual, JET_COLTYP _far *pcoltyp, JET_GRBIT grbit, unsigned long InfoLevel); /***************************************************************************** LINK API *****************************************************************************/ JET_ERR JET_API JetCreateLink(JET_SESID sesid, JET_DBID dbid, const char _far *szLink, JET_DBID dbidFrom, const char _far *szFrom, JET_GRBIT grbit); JET_ERR JET_API JetExecuteSql(JET_SESID sesid, JET_DBID dbid, const char _far *szSql); /*************************************************************************** Query API *****************************************************************************/ JET_ERR JET_API JetOpenVtQbe(JET_SESID sesid, const char _far *szExpn, long _far *plCols, JET_TABLEID _far *ptableid, JET_GRBIT grbit); JET_ERR JET_API JetCreateQuery(JET_SESID sesid, JET_DBID dbid, const char _far *szQuery, JET_TABLEID _far *ptableid); JET_ERR JET_API JetOpenQueryDef(JET_SESID sesid, JET_DBID dbid, const char _far *szQuery, JET_TABLEID _far *ptableid); /* CONSIDER: Is rgchSql a zero-terminated string? Maybe it should be for * consistency. */ JET_ERR JET_API JetSetQoSql(JET_SESID sesid, JET_TABLEID tableid, char _far *rgchSql, unsigned long cchSql, const char _far *szConnect, JET_GRBIT grbit); JET_ERR JET_API JetRetrieveQoSql(JET_SESID sesid, JET_TABLEID tableid, char _far *rgchSql, unsigned long cchMax, unsigned long _far *pcchActual, void _far *pvConnect, unsigned long cbConnectMax, unsigned long _far *pcbConnectActual, JET_GRBIT _far *pgrbit); JET_ERR JET_API JetCopyQuery(JET_SESID sesid, JET_TABLEID tableidSrc, JET_DBID dbidDest, const char _far *szQueryDest, JET_TABLEID _far *ptableidDest); JET_ERR JET_API JetOpenSVT(JET_SESID sesid, JET_DBID dbid, const char _far *szQuery, const void _far *pvParameters, unsigned long cbParameters, unsigned long crowSample, JET_GRBIT grbit, void _far *pmgblist, unsigned long cbMax, unsigned long _far *pcbActual); JET_ERR JET_API JetGetQueryParameterInfo(JET_SESID sesid, JET_DBID dbid, const char _far *szQuery, void _far *pvResult, unsigned long cbMax, unsigned long _far *pcbActual); JET_ERR JET_API JetRestartQuery(JET_SESID sesid, JET_TABLEID tableid, const void _far *pvParameters, unsigned long cbParameters); JET_ERR JET_API JetSetFatCursor(JET_SESID sesid, JET_TABLEID tableid, void _far *pvBookmark, unsigned long cbBookmark, unsigned long crowSize); JET_ERR JET_API JetFillFatCursor(JET_SESID sesid, JET_TABLEID tableid, void _far *pvBookmark, unsigned long cbBookmark, unsigned long crow, unsigned long _far *pcrow, JET_GRBIT grbit); JET_ERR JET_API JetExecuteTempQuery(JET_SESID sesid, JET_DBID dbid, JET_TABLEID tableid, const void _far *pvParameters, unsigned long cbParameters, JET_GRBIT grbit, JET_TABLEID _far *ptableid); JET_ERR JET_API JetExecuteTempSVT(JET_SESID sesid, JET_DBID dbid, JET_TABLEID tableid, const void _far *pvParameters, unsigned long cbParameters, unsigned long crowSample, JET_GRBIT grbit, void _far *pmgblist, unsigned long cbMax, unsigned long _far *pcbActual); JET_ERR JET_API JetGetTempQueryColumnInfo(JET_SESID sesid, JET_DBID dbid, JET_TABLEID tableid, const char _far *szColumnName, void _far *pvResult, unsigned long cbMax, unsigned long InfoLevel); JET_ERR JET_API JetGetTempQueryParameterInfo(JET_SESID sesid, JET_DBID dbid, JET_TABLEID tableid, void _far *pvResult, unsigned long cbMax, unsigned long _far *pcbActual); JET_ERR JET_API JetValidateData(JET_SESID sesid, JET_TABLEID tableidBase, JET_TABLEID _far *ptableid ); /*************************************************************************** API for Installable ISAMs ****************************************************************************/ typedef unsigned long JET_VSESID; /* Received from dispatcher */ struct tagVDBFNDEF; typedef unsigned long JET_VDBID; /* Received from dispatcher */ JET_ERR JET_API JetAllocateDbid(JET_SESID sesid, JET_DBID _far *pdbid, JET_VDBID vdbid, const struct tagVDBFNDEF _far *pvdbfndef, JET_VSESID vsesid); JET_ERR JET_API JetUpdateDbid(JET_SESID sesid, JET_DBID dbid, JET_VDBID vdbid, const struct tagVDBFNDEF _far *pvdbfndef); JET_ERR JET_API JetReleaseDbid(JET_SESID sesid, JET_DBID dbid); struct tagVTFNDEF; typedef unsigned long JET_VTID; /* Received from dispatcher */ JET_ERR JET_API JetAllocateTableid(JET_SESID sesid, JET_TABLEID _far *ptableid, JET_VTID vtid, const struct tagVTFNDEF _far *pvtfndef, JET_VSESID vsesid); JET_ERR JET_API JetUpdateTableid(JET_SESID sesid, JET_TABLEID tableid, JET_VTID vtid, const struct tagVTFNDEF _far *pvtfndef); JET_ERR JET_API JetReleaseTableid(JET_SESID sesid, JET_TABLEID tableid); JET_ERR JET_API JetOpenTempTable(JET_SESID sesid, const JET_COLUMNDEF _far *prgcolumndef, unsigned long ccolumn, JET_GRBIT grbit, JET_TABLEID _far *ptableid, JET_COLUMNID _far *prgcolumnid); /*************************************************************************** MISC JET API ****************************************************************************/ JET_ERR JET_API JetStringCompare(char _far *pb1, unsigned long cb1, char _far *pb2, unsigned long cb2, unsigned long sort, long _far *plResult); /*************************************************************************** ADDITIONAL JET BLUE API ****************************************************************************/ JET_ERR JET_API JetBackup( const char _far *szBackupPath, JET_GRBIT grbit ); JET_ERR JET_API JetRestore(const char _far *sz, int crstmap, JET_RSTMAP *rgrstmap, JET_PFNSTATUS pfn ); JET_ERR JET_API JetSetIndexRange(JET_SESID sesid, JET_TABLEID tableidSrc, JET_GRBIT grbit); JET_ERR JET_API JetIndexRecordCount(JET_SESID sesid, JET_TABLEID tableid, unsigned long _far *pcrec, unsigned long crecMax ); JET_ERR JET_API JetRetrieveKey(JET_SESID sesid, JET_TABLEID tableid, void _far *pvData, unsigned long cbMax, unsigned long _far *pcbActual, JET_GRBIT grbit ); #ifdef JETSER JET_ERR JET_API JetGetChecksum( JET_SESID sesid, JET_TABLEID tableid, unsigned long _far *pulChecksum ); JET_ERR JET_API JetGetObjidFromName(JET_SESID sesid, JET_DBID dbid, const char _far *szContainerName, const char _far *szObjectName, unsigned long _far *pulObjectId ); #endif #endif /* _JET_NOPROTOTYPES */ #undef _far #pragma pack() #ifdef __cplusplus } #endif #endif /* _JET_INCLUDED */ #endif __JET500