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
| <table border="1" cellpadding="2">
<tr><td colspan="3">Cursor Location</td></tr>
<tr>
<td><b>Constant</b></td>
<td><b>Value</b></td>
<td><b>Description</b></td>
</tr><tr>
<td><b>adUseClient</b></td>
<td>3</td>
<td>Use client-side cursor supplied by the local cursor library</td>
</tr><tr>
<td><b>adUseClientBatch</b></td>
<td>3</td>
<td>Obsolete, same as <b>adUseClient</b></td>
</tr><tr>
<td><b>adUseNone</b></td>
<td>1</td>
<td>Obsolete, no cursor service</td>
</tr><tr>
<td><b>adUseServer</b></td>
<td>2</td>
<td>Default, use the cursor supplied by provider or database</td>
</tr>
</table><br>
<table border="1" cellpadding="2">
<tr><td colspan="3">Cursor Type</td></tr>
<tr>
<td><b>Constant</b></td>
<td><b>Value</b></td>
<td><b>Description</b></td>
</tr><tr>
<td><b>adOpenDynamic</b></td>
<td>2</td>
<td>A dynamic cursor with both forward and backward scrolling where additions, deletions,
insertions, and updates made by other users are visible</td>
</tr><tr>
<td><b>adOpenForwardOnly</b></td>
<td>0</td>
<td>Default, a forward scrolling only, static cursor where changes made by other
users are not visible</td>
</tr><tr>
<td><b>adOpenKeyset</b></td>
<td>1</td>
<td>A keyset cursor allows you to see dynamic changes to a specific group of records
but you cannot see new records added by other users</td>
</tr><tr>
<td><b>adOpenStatic</b></td>
<td>3</td>
<td>A static cursor allowing forward and backward scrolling of a fixed, unchangeable
set of records</td>
</tr><tr>
<td><b>adOpenUnspecified</b></td>
<td>-1</td>
<td>Cursor type not specified</td>
</tr>
</table><br>
<table border="1" cellpadding="2">
<tr><td colspan="3">Lock Type</td></tr>
<tr>
<td><b>Constant</b></td>
<td><b>Value</b></td>
<td><b>Description</b></td>
</tr><tr>
<td><b>adLockBatchOptimistic</b></td>
<td>4</td>
<td>Multiple users can modify the data and the changes are cached until
<b>BatchUpdate</b> is called</td>
</tr><tr>
<td><b>adLockOptimistic</b></td>
<td>3</td>
<td>Multiple users can modify the data which is not locked until
<b>Update</b> is called</td>
</tr><tr>
<td><b>adLockPessimistic</b></td>
<td>2</td>
<td>The provider locks each record before and after you edit, and
prevents other users from modifying the data</td>
</tr><tr>
<td><b>adLockReadOnly</b></td>
<td>1</td>
<td>Read-only data</td>
</tr><tr>
<td><b>adLockUnspecified</b></td>
<td>-1</td>
<td>Lock type unknown</td>
</tr>
</table><br> |
Partager