Skip to content

Commit a756565

Browse files
authored
Merge pull request #16708 from DCtheGeek/dmc-links-sql-ado-18
Links: SQL - ADO - 18
2 parents 034abaa + 4bcc6a0 commit a756565

9 files changed

Lines changed: 41 additions & 61 deletions

docs/ado/reference/rds-api/sortdirection-property-rds.md

Lines changed: 6 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -30,20 +30,18 @@ DataControl.SortDirection = value
3030

3131
#### Parameters
3232
*DataControl*
33-
An object variable that represents an [RDS.DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) object.
33+
An object variable that represents an [RDS.DataControl](./datacontrol-object-rds.md) object.
3434

3535
*Value*
3636
A **Boolean** value that, when set to **True**, indicates the sort direction is ascending. **False** indicates descending order.
3737

3838
## Remarks
39-
The [SortColumn](../../../ado/reference/rds-api/sortcolumn-property-rds.md), **SortDirection**, [FilterValue](../../../ado/reference/rds-api/filtervalue-property-rds.md), [FilterCriterion](../../../ado/reference/rds-api/filtercriterion-property-rds.md), and [FilterColumn](../../../ado/reference/rds-api/filtercolumn-property-rds.md) properties provide sorting and filtering functionality on the client-side cache. The sorting functionality orders records by using values from one column. The filtering functionality displays a subset of records based on find criteria, while the full [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md) is maintained in the cache. The [Reset](../../../ado/reference/rds-api/reset-method-rds.md) method will execute the criteria and replace the current **Recordset** with an updatable **Recordset**.
39+
The [SortColumn](./sortcolumn-property-rds.md), **SortDirection**, [FilterValue](./filtervalue-property-rds.md), [FilterCriterion](./filtercriterion-property-rds.md), and [FilterColumn](./filtercolumn-property-rds.md) properties provide sorting and filtering functionality on the client-side cache. The sorting functionality orders records by using values from one column. The filtering functionality displays a subset of records based on find criteria, while the full [Recordset](../ado-api/recordset-object-ado.md) is maintained in the cache. The [Reset](./reset-method-rds.md) method will execute the criteria and replace the current **Recordset** with an updatable **Recordset**.
4040

4141
## Applies To
42-
[DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md)
42+
[DataControl Object (RDS)](./datacontrol-object-rds.md)
4343

4444
## See Also
45-
[FilterColumn, FilterCriterion, FilterValue, SortColumn, and SortDirection Properties and Reset Method Example (VBScript)](../../../ado/reference/rds-api/filter-column-criterion-value-sortcolumn-sortdirection-example-vbscript.md)
46-
[Sort Property](../../../ado/reference/ado-api/sort-property.md)
47-
[SortColumn Property (RDS)](../../../ado/reference/rds-api/sortcolumn-property-rds.md)
48-
49-
45+
[FilterColumn, FilterCriterion, FilterValue, SortColumn, and SortDirection Properties and Reset Method Example (VBScript)](./filter-column-criterion-value-sortcolumn-sortdirection-example-vbscript.md)
46+
[Sort Property](../ado-api/sort-property.md)
47+
[SortColumn Property (RDS)](./sortcolumn-property-rds.md)

docs/ado/reference/rds-api/sql-property-example-vbscript.md

Lines changed: 3 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ ms.author: jroth
2020
> [!IMPORTANT]
2121
> Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to [WCF Data Service](https://go.microsoft.com/fwlink/?LinkId=199565).
2222
23-
The following code shows how to set the [RDS.DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) SQL parameter at design time and bind it to a data-aware control using the database called *Pubs*, which ships with Microsoft SQL Server. To test the example, copy the following code into a normal ASP document named **SQLDesignVBS.asp** on your Web server.
23+
The following code shows how to set the [RDS.DataControl](./datacontrol-object-rds.md) SQL parameter at design time and bind it to a data-aware control using the database called *Pubs*, which ships with Microsoft SQL Server. To test the example, copy the following code into a normal ASP document named **SQLDesignVBS.asp** on your Web server.
2424

2525
```
2626
<!-- BeginSQLDesignVBS -->
@@ -170,8 +170,5 @@ End Sub
170170
```
171171

172172
## See Also
173-
[DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md)
174-
[SQL Property](../../../ado/reference/rds-api/sql-property.md)
175-
176-
177-
173+
[DataControl Object (RDS)](./datacontrol-object-rds.md)
174+
[SQL Property](./sql-property.md)

docs/ado/reference/rds-api/sql-property.md

Lines changed: 8 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -16,9 +16,9 @@ author: rothja
1616
ms.author: jroth
1717
---
1818
# SQL Property
19-
Indicates the query string used to retrieve the [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md).
19+
Indicates the query string used to retrieve the [Recordset](../ado-api/recordset-object-ado.md).
2020

21-
You can set the **SQL** property at design time in the [RDS.DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) object's OBJECT tags, or at run time in scripting code.
21+
You can set the **SQL** property at design time in the [RDS.DataControl](./datacontrol-object-rds.md) object's OBJECT tags, or at run time in scripting code.
2222

2323
> [!IMPORTANT]
2424
> Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to [WCF Data Service](https://go.microsoft.com/fwlink/?LinkId=199565).
@@ -44,13 +44,11 @@ Run time: DataControl.SQL = "QueryString"
4444
The **SQL** property is optional if a custom server-side business object retrieves the data for the client.
4545

4646
## Applies To
47-
[DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md)
47+
[DataControl Object (RDS)](./datacontrol-object-rds.md)
4848

4949
## See Also
50-
[SQL Property Example (VBScript)](../../../ado/reference/rds-api/sql-property-example-vbscript.md)
51-
[Connect Property (RDS)](../../../ado/reference/rds-api/connect-property-rds.md)
52-
[Query Method (RDS)](../../../ado/reference/rds-api/query-method-rds.md)
53-
[Refresh Method (RDS)](../../../ado/reference/rds-api/refresh-method-rds.md)
54-
[SubmitChanges Method (RDS)](../../../ado/reference/rds-api/submitchanges-method-rds.md)
55-
56-
50+
[SQL Property Example (VBScript)](./sql-property-example-vbscript.md)
51+
[Connect Property (RDS)](./connect-property-rds.md)
52+
[Query Method (RDS)](./query-method-rds.md)
53+
[Refresh Method (RDS)](./refresh-method-rds.md)
54+
[SubmitChanges Method (RDS)](./submitchanges-method-rds.md)

docs/ado/reference/rds-api/submitchanges-method-example-vbscript.md

Lines changed: 3 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ ms.author: jroth
1919
> [!IMPORTANT]
2020
> Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to [WCF Data Service](https://go.microsoft.com/fwlink/?LinkId=199565).
2121
22-
The following code fragment shows how to use the [SubmitChanges](../../../ado/reference/rds-api/submitchanges-method-rds.md) method with an [RDS.DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) object.
22+
The following code fragment shows how to use the [SubmitChanges](./submitchanges-method-rds.md) method with an [RDS.DataControl](./datacontrol-object-rds.md) object.
2323

2424
To test this example, cut and paste this code into a normal ASP document and name it **SubmitChangesCtrlVBS.asp**. ASP script will identify your server.
2525

@@ -112,7 +112,5 @@ End Sub
112112
```
113113

114114
## See Also
115-
[DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md)
116-
[SubmitChanges Method (RDS)](../../../ado/reference/rds-api/submitchanges-method-rds.md)
117-
118-
115+
[DataControl Object (RDS)](./datacontrol-object-rds.md)
116+
[SubmitChanges Method (RDS)](./submitchanges-method-rds.md)

docs/ado/reference/rds-api/submitchanges-method-rds.md

Lines changed: 12 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -16,7 +16,7 @@ author: rothja
1616
ms.author: jroth
1717
---
1818
# SubmitChanges Method (RDS)
19-
Submits pending changes of the locally cached and updatable [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md) to the data source specified in the [Connect](../../../ado/reference/rds-api/connect-property-rds.md) property or the [URL](../../../ado/reference/rds-api/url-property-rds.md) property.
19+
Submits pending changes of the locally cached and updatable [Recordset](../ado-api/recordset-object-ado.md) to the data source specified in the [Connect](./connect-property-rds.md) property or the [URL](./url-property-rds.md) property.
2020

2121
> [!IMPORTANT]
2222
> Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to [WCF Data Service](https://go.microsoft.com/fwlink/?LinkId=199565).
@@ -30,21 +30,21 @@ DataControl.SubmitChanges DataFactory.SubmitChanges Connection, Recordset
3030

3131
#### Parameters
3232
*DataControl*
33-
An object variable that represents an [RDS.DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) object.
33+
An object variable that represents an [RDS.DataControl](./datacontrol-object-rds.md) object.
3434

3535
*DataFactory*
36-
An object variable that represents an [RDSServer.DataFactory](../../../ado/reference/rds-api/datafactory-object-rdsserver.md) object.
36+
An object variable that represents an [RDSServer.DataFactory](./datafactory-object-rdsserver.md) object.
3737

3838
*Connection*
39-
A **String** value that represents the connection created with the **RDS.DataControl** object's [Connect](../../../ado/reference/rds-api/connect-property-rds.md) property.
39+
A **String** value that represents the connection created with the **RDS.DataControl** object's [Connect](./connect-property-rds.md) property.
4040

4141
*Recordset*
4242
An object variable that represents a **Recordset** object.
4343

4444
## Remarks
45-
The [Connect](../../../ado/reference/rds-api/connect-property-rds.md), [Server](../../../ado/reference/rds-api/server-property-rds.md), and [SQL](../../../ado/reference/rds-api/sql-property.md) properties must be set before you can use the **SubmitChanges** method with the **RDS.DataControl** object.
45+
The [Connect](./connect-property-rds.md), [Server](./server-property-rds.md), and [SQL](./sql-property.md) properties must be set before you can use the **SubmitChanges** method with the **RDS.DataControl** object.
4646

47-
If you call the [CancelUpdate](../../../ado/reference/rds-api/cancelupdate-method-rds.md) method after you have called **SubmitChanges** for the same **Recordset** object, the **CancelUpdate** call fails because the changes have already been committed.
47+
If you call the [CancelUpdate](./cancelupdate-method-rds.md) method after you have called **SubmitChanges** for the same **Recordset** object, the **CancelUpdate** call fails because the changes have already been committed.
4848

4949
Only the changed records are sent for modification, and either all of the changes succeed or all the changes fail together.
5050

@@ -56,18 +56,15 @@ DataControl.SubmitChanges DataFactory.SubmitChanges Connection, Recordset
5656

5757
:::row:::
5858
:::column:::
59-
[DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md)
59+
[DataControl Object (RDS)](./datacontrol-object-rds.md)
6060
:::column-end:::
6161
:::column:::
62-
[DataFactory Object (RDSServer)](../../../ado/reference/rds-api/datafactory-object-rdsserver.md)
62+
[DataFactory Object (RDSServer)](./datafactory-object-rdsserver.md)
6363
:::column-end:::
6464
:::row-end:::
6565

6666
## See Also
67-
[SubmitChanges Method Example (VBScript)](../../../ado/reference/rds-api/submitchanges-method-example-vbscript.md)
68-
[Address Book Command Buttons](../../../ado/guide/remote-data-service/address-book-command-buttons.md)
69-
[CancelUpdate Method (RDS)](../../../ado/reference/rds-api/cancelupdate-method-rds.md)
70-
[Refresh Method (RDS)](../../../ado/reference/rds-api/refresh-method-rds.md)
71-
72-
73-
67+
[SubmitChanges Method Example (VBScript)](./submitchanges-method-example-vbscript.md)
68+
[Address Book Command Buttons](../../guide/remote-data-service/address-book-command-buttons.md)
69+
[CancelUpdate Method (RDS)](./cancelupdate-method-rds.md)
70+
[Refresh Method (RDS)](./refresh-method-rds.md)

docs/ado/reference/rds-api/synchronize-method-rds.md

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -62,6 +62,4 @@ object.Synchronize(ConnectionString As String, HandlerString As String, lSynchro
6262
The *HandlerString* parameter may be null. What happens in this case depends on how the RDS server is configured. A handler string of "MSDFMAP.handler" indicates that the Microsoft supplied handler (Msdfmap.dll) should be used. A handler string of "MASDFMAP.handler,sample.ini" indicates that the Msdfmap.dll handler should be used and that the argument "sample.ini" should be passed to the handler. Msdfmap.dll will then interpret the argument as a direction to use the sample.ini to check the connection and query strings.
6363

6464
## Applies To
65-
[DataFactory Object (RDSServer)](../../../ado/reference/rds-api/datafactory-object-rdsserver.md)
66-
67-
65+
[DataFactory Object (RDSServer)](./datafactory-object-rdsserver.md)

docs/ado/reference/rds-api/synchronize21-method-rds.md

Lines changed: 2 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -56,9 +56,7 @@ object.Synchronize21(ConnectionString As String, HandlerString As String, lSynch
5656
The *HandlerString* parameter can be null. What happens in this case depends on how the RDS server is configured. A handler string of "MSDFMAP.handler" indicates that the Microsoft supplied handler (Msdfmap.dll) should be used. A handler string of "MASDFMAP.handler,sample.ini" indicates that the Msdfmap.dll handler should be used and that the argument "sample.ini" should be passed to the handler. Msdfmap.dll will then interpret the argument as a direction to use the sample.ini to check the connection and query strings.
5757

5858
> [!NOTE]
59-
> The **Synchronize21** method is simply a version of the [Synchronize Method (RDS)](../../../ado/reference/rds-api/synchronize-method-rds.md). Where you need to use the **Synchronize** method to communicate with ADO 2.1, the **Synchronize21** method can be called instead. The capabilities of the **Synchronize** method in ADO 2.5 and later are a superset of the capabilities provided for the same method in ADO 2.1.
59+
> The **Synchronize21** method is simply a version of the [Synchronize Method (RDS)](./synchronize-method-rds.md). Where you need to use the **Synchronize** method to communicate with ADO 2.1, the **Synchronize21** method can be called instead. The capabilities of the **Synchronize** method in ADO 2.5 and later are a superset of the capabilities provided for the same method in ADO 2.1.
6060
6161
## Applies To
62-
[DataFactory Object (RDSServer)](../../../ado/reference/rds-api/datafactory-object-rdsserver.md)
63-
64-
62+
[DataFactory Object (RDSServer)](./datafactory-object-rdsserver.md)

docs/ado/reference/rds-api/url-property-example-vbscript.md

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -134,6 +134,4 @@ End Sub
134134
```
135135

136136
## See Also
137-
[URL Property (RDS)](../../../ado/reference/rds-api/url-property-rds.md)
138-
139-
137+
[URL Property (RDS)](./url-property-rds.md)

docs/ado/reference/rds-api/url-property-rds.md

Lines changed: 5 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -18,7 +18,7 @@ ms.author: jroth
1818
# URL Property (RDS)
1919
Indicates a string that contains a relative or absolute URL.
2020

21-
You can set the **URL** property at design time in the [DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) object's OBJECT tag, or at run time in scripting code.
21+
You can set the **URL** property at design time in the [DataControl](./datacontrol-object-rds.md) object's OBJECT tag, or at run time in scripting code.
2222

2323
> [!IMPORTANT]
2424
> Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to [WCF Data Service](https://go.microsoft.com/fwlink/?LinkId=199565).
@@ -39,14 +39,12 @@ Run time: DataControl.URL="Server"
3939
An object variable that represents a **DataControl** object.
4040

4141
## Remarks
42-
Typically, the URL identifies an Active Server Page (.asp) file that can produce and return a [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md). Therefore, the user can obtain a **Recordset** without having to invoke the server-side [DataFactory](../../../ado/reference/rds-api/datafactory-object-rdsserver.md) object, or program a custom business object.
42+
Typically, the URL identifies an Active Server Page (.asp) file that can produce and return a [Recordset](../ado-api/recordset-object-ado.md). Therefore, the user can obtain a **Recordset** without having to invoke the server-side [DataFactory](./datafactory-object-rdsserver.md) object, or program a custom business object.
4343

44-
If the **URL** property has been set, [SubmitChanges](../../../ado/reference/rds-api/submitchanges-method-rds.md) will submit changes to the location specified by the URL.
44+
If the **URL** property has been set, [SubmitChanges](./submitchanges-method-rds.md) will submit changes to the location specified by the URL.
4545

4646
## Applies To
47-
[DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md)
47+
[DataControl Object (RDS)](./datacontrol-object-rds.md)
4848

4949
## See Also
50-
[URL Property Example (VBScript)](../../../ado/reference/rds-api/url-property-example-vbscript.md)
51-
52-
50+
[URL Property Example (VBScript)](./url-property-example-vbscript.md)

0 commit comments

Comments
 (0)