Secondary Data Source Action Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ken - 23 Jul 2004 02:16 GMT

It seems we can update a database directly using Primary (Main)
database connections.
However, when I try and alter the DataAdapter's Command to an "Update
XXX set …." Type SQL statement and call the Query() method although no
error is thrown the database is not updated.

How can turn a Select query into an Action Query on a secondary Data
Source?

-Ken

Reply to this Message

Steve van Dongen [MSFT] - 23 Jul 2004 20:52 GMT

>It seems we can update a database directly using Primary (Main)
>database connections.
[quoted text clipped - 4 lines]
>How can turn a Select query into an Action Query on a secondary Data
>Source?

You probably have the secondary datasource set to Receive Only.
However, to issue an UPDATE statement all you need is ADO.

var oConn = new ActiveXObject("ADODB.Connection");
oConn.ConnectionString = XDocument.QueryAdapter.Connection;
oConn.ConnectionTimeout = XDocument.QueryAdapter.Timeout;
oConn.Open();
oConn.Execute("UPDATE ...");
oConn.Close();

Regards,
Steve
--
Please post questions to the newsgroup; everyone benefits.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm

Reply to this Message