Skip to content

Commit a7425a8

Browse files
DCtheGeekDCtheGeek
committed
Links: SQL - ADO - 6
1 parent 4befb5f commit a7425a8

50 files changed

Lines changed: 345 additions & 345 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/ado/reference/ado-api/clone-method-example-vbscript.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ author: rothja
1717
ms.author: jroth
1818
---
1919
# Clone Method Example (VBScript)
20-
This example uses the [Clone](../../../ado/reference/ado-api/clone-method-ado.md) method to create copies of a [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md) and then lets the user position the record pointer of each copy independently.
20+
This example uses the [Clone](./clone-method-ado.md) method to create copies of a [Recordset](./recordset-object-ado.md) and then lets the user position the record pointer of each copy independently.
2121

2222
Use the following example in an Active Server Page (ASP). This example uses the **Northwind** database distributed with Microsoft Access. Cut and paste the following code to Notepad or another text editor and save it as CloneVBS.asp. You can view the result in any client browser.
2323

@@ -113,5 +113,5 @@ This example uses the [Clone](../../../ado/reference/ado-api/clone-method-ado.md
113113
```
114114

115115
## See Also
116-
[Clone Method (ADO)](../../../ado/reference/ado-api/clone-method-ado.md)
117-
[Recordset Object (ADO)](../../../ado/reference/ado-api/recordset-object-ado.md)
116+
[Clone Method (ADO)](./clone-method-ado.md)
117+
[Recordset Object (ADO)](./recordset-object-ado.md)

‎docs/ado/reference/ado-api/clone-method-example-vc.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -17,7 +17,7 @@ author: rothja
1717
ms.author: jroth
1818
---
1919
# Clone Method Example (VC++)
20-
This example uses the [Clone](../../../ado/reference/ado-api/clone-method-ado.md) method to create copies of a [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md) and then lets the user position the record pointer of each copy independently.
20+
This example uses the [Clone](./clone-method-ado.md) method to create copies of a [Recordset](./recordset-object-ado.md) and then lets the user position the record pointer of each copy independently.
2121

2222
```
2323
// BeginCloneCpp.cpp
@@ -215,4 +215,4 @@ void PrintComError(_com_error &e) {
215215
```
216216

217217
## See Also
218-
[Recordset Object (ADO)](../../../ado/reference/ado-api/recordset-object-ado.md)
218+
[Recordset Object (ADO)](./recordset-object-ado.md)

‎docs/ado/reference/ado-api/close-method-ado.md‎

Lines changed: 16 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -30,41 +30,41 @@ object.Close
3030
```
3131

3232
## Remarks
33-
Use the **Close** method to close a [Connection](../../../ado/reference/ado-api/connection-object-ado.md), a [Record](../../../ado/reference/ado-api/record-object-ado.md), a [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md), or a [Stream](../../../ado/reference/ado-api/stream-object-ado.md) object to free any associated system resources. Closing an object does not remove it from memory; you can change its property settings and open it again later. To completely eliminate an object from memory, close the object and then set the object variable to *Nothing* (in Visual Basic).
33+
Use the **Close** method to close a [Connection](./connection-object-ado.md), a [Record](./record-object-ado.md), a [Recordset](./recordset-object-ado.md), or a [Stream](./stream-object-ado.md) object to free any associated system resources. Closing an object does not remove it from memory; you can change its property settings and open it again later. To completely eliminate an object from memory, close the object and then set the object variable to *Nothing* (in Visual Basic).
3434

3535
## Connection
36-
Using the **Close** method to close a **Connection** object also closes any active **Recordset** objects associated with the connection. A [Command](../../../ado/reference/ado-api/command-object-ado.md) object associated with the **Connection** object you are closing will persist, but it will no longer be associated with a **Connection** object; that is, its [ActiveConnection](../../../ado/reference/ado-api/activeconnection-property-ado.md) property will be set to **Nothing**. Also, the **Command** object's [Parameters](../../../ado/reference/ado-api/parameters-collection-ado.md) collection will be cleared of any provider-defined parameters.
36+
Using the **Close** method to close a **Connection** object also closes any active **Recordset** objects associated with the connection. A [Command](./command-object-ado.md) object associated with the **Connection** object you are closing will persist, but it will no longer be associated with a **Connection** object; that is, its [ActiveConnection](./activeconnection-property-ado.md) property will be set to **Nothing**. Also, the **Command** object's [Parameters](./parameters-collection-ado.md) collection will be cleared of any provider-defined parameters.
3737

38-
You can later call the [Open](../../../ado/reference/ado-api/open-method-ado-connection.md) method to re-establish the connection to the same, or another, data source. While the **Connection** object is closed, calling any methods that require an open connection to the data source generates an error.
38+
You can later call the [Open](./open-method-ado-connection.md) method to re-establish the connection to the same, or another, data source. While the **Connection** object is closed, calling any methods that require an open connection to the data source generates an error.
3939

4040
Closing a **Connection** object while there are open **Recordset** objects on the connection rolls back any pending changes in all of the **Recordset** objects. Explicitly closing a **Connection** object (calling the **Close** method) while a transaction is in progress generates an error. If a **Connection** object falls out of scope while a transaction is in progress, ADO automatically rolls back the transaction.
4141

4242
## Recordset, Record, Stream
43-
Using the **Close** method to close a **Recordset**, **Record**, or **Stream** object releases the associated data and any exclusive access you may have had to the data through this particular object. You can later call the [Open](../../../ado/reference/ado-api/open-method-ado-recordset.md) method to reopen the object with the same, or modified, attributes.
43+
Using the **Close** method to close a **Recordset**, **Record**, or **Stream** object releases the associated data and any exclusive access you may have had to the data through this particular object. You can later call the [Open](./open-method-ado-recordset.md) method to reopen the object with the same, or modified, attributes.
4444

4545
While a **Recordset** object is closed, calling any methods that require a live cursor generates an error.
4646

47-
If an edit is in progress while in immediate update mode, calling the **Close** method generates an error; instead, call the [Update](../../../ado/reference/ado-api/update-method.md) or [CancelUpdate](../../../ado/reference/ado-api/cancelupdate-method-ado.md) method first. If you close the **Recordset** object while in batch update mode, all changes since the last [UpdateBatch](../../../ado/reference/ado-api/updatebatch-method.md) call are lost.
47+
If an edit is in progress while in immediate update mode, calling the **Close** method generates an error; instead, call the [Update](./update-method.md) or [CancelUpdate](./cancelupdate-method-ado.md) method first. If you close the **Recordset** object while in batch update mode, all changes since the last [UpdateBatch](./updatebatch-method.md) call are lost.
4848

49-
If you use the [Clone](../../../ado/reference/ado-api/clone-method-ado.md) method to create copies of an open **Recordset** object, closing the original or a clone does not affect any of the other copies.
49+
If you use the [Clone](./clone-method-ado.md) method to create copies of an open **Recordset** object, closing the original or a clone does not affect any of the other copies.
5050

5151
## Applies To
5252

5353
:::row:::
5454
:::column:::
55-
[Connection Object (ADO)](../../../ado/reference/ado-api/connection-object-ado.md)
56-
[Record Object (ADO)](../../../ado/reference/ado-api/record-object-ado.md)
55+
[Connection Object (ADO)](./connection-object-ado.md)
56+
[Record Object (ADO)](./record-object-ado.md)
5757
:::column-end:::
5858
:::column:::
59-
[Recordset Object (ADO)](../../../ado/reference/ado-api/recordset-object-ado.md)
60-
[Stream Object (ADO)](../../../ado/reference/ado-api/stream-object-ado.md)
59+
[Recordset Object (ADO)](./recordset-object-ado.md)
60+
[Stream Object (ADO)](./stream-object-ado.md)
6161
:::column-end:::
6262
:::row-end:::
6363

6464
## See Also
65-
[Open and Close Methods Example (VB)](../../../ado/reference/ado-api/open-and-close-methods-example-vb.md)
66-
[Open and Close Methods Example (VBScript)](../../../ado/reference/ado-api/open-and-close-methods-example-vbscript.md)
67-
[Open and Close Methods Example (VC++)](../../../ado/reference/ado-api/open-and-close-methods-example-vc.md)
68-
[Open Method (ADO Connection)](../../../ado/reference/ado-api/open-method-ado-connection.md)
69-
[Open Method (ADO Recordset)](../../../ado/reference/ado-api/open-method-ado-recordset.md)
70-
[Save Method](../../../ado/reference/ado-api/save-method.md)
65+
[Open and Close Methods Example (VB)](./open-and-close-methods-example-vb.md)
66+
[Open and Close Methods Example (VBScript)](./open-and-close-methods-example-vbscript.md)
67+
[Open and Close Methods Example (VC++)](./open-and-close-methods-example-vc.md)
68+
[Open Method (ADO Connection)](./open-method-ado-connection.md)
69+
[Open Method (ADO Recordset)](./open-method-ado-recordset.md)
70+
[Save Method](./save-method.md)

‎docs/ado/reference/ado-api/collections-ado-for-visual-c-syntax.md‎

Lines changed: 21 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -32,11 +32,11 @@ Refresh(void);
3232

3333
For more information, see
3434

35-
- [Append Method (ADO)](../../../ado/reference/ado-api/append-method-ado.md)
35+
- [Append Method (ADO)](./append-method-ado.md)
3636

37-
- [Delete Method (ADO Parameters Collection)](../../../ado/reference/ado-api/delete-method-ado-parameters-collection.md)
37+
- [Delete Method (ADO Parameters Collection)](./delete-method-ado-parameters-collection.md)
3838

39-
- [Refresh Method (ADO)](../../../ado/reference/ado-api/refresh-method-ado.md)
39+
- [Refresh Method (ADO)](./refresh-method-ado.md)
4040

4141
### Properties
4242

@@ -47,9 +47,9 @@ get_Item(VARIANT Index, _ADOParameter **ppvObject);
4747

4848
For more information, see
4949

50-
- [Count Property (ADO)](../../../ado/reference/ado-api/count-property-ado.md)
50+
- [Count Property (ADO)](./count-property-ado.md)
5151

52-
- [Item Property (ADO)](../../../ado/reference/ado-api/item-property-ado.md)
52+
- [Item Property (ADO)](./item-property-ado.md)
5353

5454
## Fields
5555

@@ -63,11 +63,11 @@ Refresh(void);
6363

6464
For more information, see
6565

66-
- [Append Method (ADO)](../../../ado/reference/ado-api/append-method-ado.md)
66+
- [Append Method (ADO)](./append-method-ado.md)
6767

68-
- [Delete Method (ADO Parameters Collection)](../../../ado/reference/ado-api/delete-method-ado-parameters-collection.md)
68+
- [Delete Method (ADO Parameters Collection)](./delete-method-ado-parameters-collection.md)
6969

70-
- [Refresh Method (ADO)](../../../ado/reference/ado-api/refresh-method-ado.md)
70+
- [Refresh Method (ADO)](./refresh-method-ado.md)
7171

7272
### Properties
7373

@@ -78,9 +78,9 @@ get_Item(VARIANT Index, ADOField **ppvObject);
7878

7979
For more information, see
8080

81-
- [Count Property (ADO)](../../../ado/reference/ado-api/count-property-ado.md)
81+
- [Count Property (ADO)](./count-property-ado.md)
8282

83-
- [Item Property (ADO)](../../../ado/reference/ado-api/item-property-ado.md)
83+
- [Item Property (ADO)](./item-property-ado.md)
8484

8585
## Errors
8686

@@ -93,9 +93,9 @@ Refresh(void);
9393

9494
For more information, see
9595

96-
- [Clear Method (ADO)](../../../ado/reference/ado-api/clear-method-ado.md)
96+
- [Clear Method (ADO)](./clear-method-ado.md)
9797

98-
- [Refresh Method (ADO)](../../../ado/reference/ado-api/refresh-method-ado.md)
98+
- [Refresh Method (ADO)](./refresh-method-ado.md)
9999

100100
### Properties
101101

@@ -106,9 +106,9 @@ get_Item(VARIANT Index, ADOError **ppvObject);
106106

107107
For more information, see
108108

109-
- [Count Property (ADO)](../../../ado/reference/ado-api/count-property-ado.md)
109+
- [Count Property (ADO)](./count-property-ado.md)
110110

111-
- [Item Property (ADO)](../../../ado/reference/ado-api/item-property-ado.md)
111+
- [Item Property (ADO)](./item-property-ado.md)
112112

113113
## Properties
114114

@@ -120,7 +120,7 @@ Refresh(void);
120120

121121
For more information, see
122122

123-
- [Refresh Method (ADO)](../../../ado/reference/ado-api/refresh-method-ado.md)
123+
- [Refresh Method (ADO)](./refresh-method-ado.md)
124124

125125
### Properties
126126

@@ -131,12 +131,12 @@ get_Item(VARIANT Index, ADOProperty **ppvObject);
131131

132132
For more information, see
133133

134-
- [Count Property (ADO)](../../../ado/reference/ado-api/count-property-ado.md)
134+
- [Count Property (ADO)](./count-property-ado.md)
135135

136-
- [Item Property (ADO)](../../../ado/reference/ado-api/item-property-ado.md)
136+
- [Item Property (ADO)](./item-property-ado.md)
137137

138138
## See Also
139-
[Errors Collection (ADO)](../../../ado/reference/ado-api/errors-collection-ado.md)
140-
[Fields Collection (ADO)](../../../ado/reference/ado-api/fields-collection-ado.md)
141-
[Parameters Collection (ADO)](../../../ado/reference/ado-api/parameters-collection-ado.md)
142-
[Properties Collection (ADO)](../../../ado/reference/ado-api/properties-collection-ado.md)
139+
[Errors Collection (ADO)](./errors-collection-ado.md)
140+
[Fields Collection (ADO)](./fields-collection-ado.md)
141+
[Parameters Collection (ADO)](./parameters-collection-ado.md)
142+
[Properties Collection (ADO)](./properties-collection-ado.md)

‎docs/ado/reference/ado-api/collections-ado-wfc-syntax.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -78,6 +78,6 @@ public int getCount()
7878
```
7979

8080
## See Also
81-
[Errors Collection (ADO)](../../../ado/reference/ado-api/errors-collection-ado.md)
82-
[Fields Collection (ADO)](../../../ado/reference/ado-api/fields-collection-ado.md)
83-
[Parameters Collection (ADO)](../../../ado/reference/ado-api/parameters-collection-ado.md)
81+
[Errors Collection (ADO)](./errors-collection-ado.md)
82+
[Fields Collection (ADO)](./fields-collection-ado.md)
83+
[Parameters Collection (ADO)](./parameters-collection-ado.md)

‎docs/ado/reference/ado-api/collections-visual-c-syntax-index-with-sharpimport.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -92,7 +92,7 @@ PropertyPtr GetItem( const _variant_t & Index ); __declspec(property(get=GetItem
9292
```
9393

9494
## See Also
95-
[Errors Collection (ADO)](../../../ado/reference/ado-api/errors-collection-ado.md)
96-
[Fields Collection (ADO)](../../../ado/reference/ado-api/fields-collection-ado.md)
97-
[Parameters Collection (ADO)](../../../ado/reference/ado-api/parameters-collection-ado.md)
98-
[Properties Collection (ADO)](../../../ado/reference/ado-api/properties-collection-ado.md)
95+
[Errors Collection (ADO)](./errors-collection-ado.md)
96+
[Fields Collection (ADO)](./fields-collection-ado.md)
97+
[Parameters Collection (ADO)](./parameters-collection-ado.md)
98+
[Properties Collection (ADO)](./properties-collection-ado.md)

‎docs/ado/reference/ado-api/command-ado-for-visual-c-syntax.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -47,4 +47,4 @@ get_Parameters(ADOParameters **ppvObject)
4747
```
4848

4949
## See Also
50-
[Command Object (ADO)](../../../ado/reference/ado-api/command-object-ado.md)
50+
[Command Object (ADO)](./command-object-ado.md)

‎docs/ado/reference/ado-api/command-ado-wfc-syntax.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -65,4 +65,4 @@ public AdoProperties getProperties()
6565
```
6666

6767
## See Also
68-
[Command Object (ADO)](../../../ado/reference/ado-api/command-object-ado.md)
68+
[Command Object (ADO)](./command-object-ado.md)

0 commit comments

Comments
 (0)