Data Connections

Re: Problems updating a table

fredarwin — Wed, 12 Jul 2006 15:51:40 GMT

I got a solution:

var cn = new ActiveXObject("ADODB.Connection");
var sqlSP = "EXEC sp_authorize " + idsolicitud;
cn.ConnectionString = XDocument.DataObjects("CatServicios").QueryAdapter.Connection;
cn.ConnectionTimeout = XDocument.DataObjects("CatServicios").QueryAdapter.Timeout;

cn.Open();
cn.Execute(sqlSP);
cn.Close();

this work fine and change data on my table.

Re: Problems updating a table

fredarwin — Wed, 12 Jul 2006 13:32:14 GMT

i try to execute by a stored procedure but i have the same problem, the code is execute but the stored procedure never is executed, and ip neves send me a error message:

var objADOAdapter;
objADOAdapter = XDocument.DataObjects("CatServicios").QueryAdapter;
XDocument.UI.Alert("SQL command text: " + objADOAdapter.Command);
try
{
objADOAdapter.Command='execute "sp_authorize" ' + 30;
XDocument.UI.Alert("SQL command text: " + objADOAdapter.Command);
objADOAdapter.Command.Execute;
}
catch(ex)
{
XDocument.UI.Alert(ex.description);
}

what is the problem?

Problems updating a table

fredarwin — Tue, 11 Jul 2006 19:42:10 GMT

Hi, i am trying to update a sql table with the next code:

XDocument.QueryAdapter.Command = "update solicitudesms set autorizado=1";
XDocument.Query();

This works fine, but is not updating my table.
i have permissions on my table.

Why???