1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
|
#pragma once
// Copyright (c) .NET Foundation and contributors. All rights reserved. Licensed under the Microsoft Reciprocal License. See LICENSE.TXT file in the project root for full license information.
#ifdef __cplusplus
extern "C" {
#endif
#define ReleaseEseQuery(pqh) if (pqh) { EseFinishQuery(pqh); }
#define ReleaseNullEseQuery(pqh) if (pqh) { EseFinishQuery(pqh); pqh = NULL; }
struct ESE_COLUMN_SCHEMA
{
JET_COLUMNID jcColumn;
LPCWSTR pszName;
JET_COLTYP jcColumnType;
BOOL fKey; // If this column is part of the key of the table
BOOL fFixed;
BOOL fNullable;
BOOL fAutoIncrement;
};
struct ESE_TABLE_SCHEMA
{
JET_TABLEID jtTable;
LPCWSTR pszName;
DWORD dwColumns;
ESE_COLUMN_SCHEMA *pcsColumns;
};
struct ESE_DATABASE_SCHEMA
{
DWORD dwTables;
ESE_TABLE_SCHEMA *ptsTables;
};
typedef enum ESE_QUERY_TYPE
{
ESE_QUERY_EXACT,
ESE_QUERY_FROM_TOP,
ESE_QUERY_FROM_BOTTOM
} ESE_QUERY_TYPE;
typedef void* ESE_QUERY_HANDLE;
HRESULT DAPI EseBeginSession(
__out JET_INSTANCE *pjiInstance,
__out JET_SESID *pjsSession,
__in_z LPCWSTR pszInstance,
__in_z LPCWSTR pszPath
);
HRESULT DAPI EseEndSession(
__in JET_INSTANCE jiInstance,
__in JET_SESID jsSession
);
HRESULT DAPI EseEnsureDatabase(
__in JET_SESID jsSession,
__in_z LPCWSTR pszFile,
__in ESE_DATABASE_SCHEMA *pdsSchema,
__out JET_DBID* pjdbDb,
__in BOOL fExclusive,
__in BOOL fReadonly
);
HRESULT DAPI EseCloseDatabase(
__in JET_SESID jsSession,
__in JET_DBID jdbDb
);
HRESULT DAPI EseCreateTable(
__in JET_SESID jsSession,
__in JET_DBID jdbDb,
__in_z LPCWSTR pszTable,
__out JET_TABLEID *pjtTable
);
HRESULT DAPI EseOpenTable(
__in JET_SESID jsSession,
__in JET_DBID jdbDb,
__in_z LPCWSTR pszTable,
__out JET_TABLEID *pjtTable
);
HRESULT DAPI EseCloseTable(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable
);
HRESULT DAPI EseEnsureColumn(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable,
__in_z LPCWSTR pszColumnName,
__in JET_COLTYP jcColumnType,
__in ULONG ulColumnSize,
__in BOOL fFixed,
__in BOOL fNullable,
__out_opt JET_COLUMNID *pjcColumn
);
HRESULT DAPI EseGetColumn(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable,
__in_z LPCWSTR pszColumnName,
__out JET_COLUMNID *pjcColumn
);
HRESULT DAPI EseMoveCursor(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable,
__in LONG lRow
);
HRESULT DAPI EseDeleteRow(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable
);
HRESULT DAPI EseBeginTransaction(
__in JET_SESID jsSession
);
HRESULT DAPI EseRollbackTransaction(
__in JET_SESID jsSession,
__in BOOL fAll
);
HRESULT DAPI EseCommitTransaction(
__in JET_SESID jsSession
);
HRESULT DAPI EsePrepareUpdate(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable,
__in ULONG ulPrep
);
HRESULT DAPI EseFinishUpdate(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable,
__in BOOL fSeekToInsertedRecord
);
HRESULT DAPI EseSetColumnBinary(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__in_bcount(cbBuffer) const BYTE* pbBuffer,
__in SIZE_T cbBuffer
);
HRESULT DAPI EseSetColumnDword(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__in DWORD dwValue
);
HRESULT DAPI EseSetColumnBool(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__in BOOL fValue
);
HRESULT DAPI EseSetColumnString(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__in_z LPCWSTR pszValue
);
HRESULT DAPI EseSetColumnEmpty(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn
);
HRESULT DAPI EseGetColumnBinary(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__deref_inout_bcount(*piBuffer) BYTE** ppbBuffer,
__inout SIZE_T* piBuffer
);
HRESULT DAPI EseGetColumnDword(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__out DWORD *pdwValue
);
HRESULT DAPI EseGetColumnBool(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__out BOOL *pfValue
);
HRESULT DAPI EseGetColumnString(
__in JET_SESID jsSession,
__in ESE_TABLE_SCHEMA tsTable,
__in DWORD dwColumn,
__out LPWSTR *ppszValue
);
// Call this once for each key column in the table
HRESULT DAPI EseBeginQuery(
__in JET_SESID jsSession,
__in JET_TABLEID jtTable,
__in ESE_QUERY_TYPE qtQueryType,
__out ESE_QUERY_HANDLE *peqhHandle
);
HRESULT DAPI EseSetQueryColumnBinary(
__in ESE_QUERY_HANDLE eqhHandle,
__in_bcount(cbBuffer) const BYTE* pbBuffer,
__in SIZE_T cbBuffer,
__in BOOL fFinal // If this is true, all other key columns in the query will be set to "*"
);
HRESULT DAPI EseSetQueryColumnDword(
__in ESE_QUERY_HANDLE eqhHandle,
__in DWORD dwData,
__in BOOL fFinal // If this is true, all other key columns in the query will be set to "*"
);
HRESULT DAPI EseSetQueryColumnBool(
__in ESE_QUERY_HANDLE eqhHandle,
__in BOOL fValue,
__in BOOL fFinal // If this is true, all other key columns in the query will be set to "*"
);
HRESULT DAPI EseSetQueryColumnString(
__in ESE_QUERY_HANDLE eqhHandle,
__in_z LPCWSTR pszString,
__in BOOL fFinal // If this is true, all other key columns in the query will be set to "*"
);
HRESULT DAPI EseFinishQuery(
__in ESE_QUERY_HANDLE eqhHandle
);
// Once all columns have been set up, call this and read the result
HRESULT DAPI EseRunQuery(
__in ESE_QUERY_HANDLE eqhHandle
);
#ifdef __cplusplus
}
#endif
|
