InfoPath Dev

I have a form published in a form library. my fields published are:
name, department, position, authorized.
I am using a main database connection to storege data.

when i submit data: firts save data to my database and then are sent to the form library

I am using Signatures by section and the fields that are signed are:
name, department, position.

Well, i need to update the authorized field after i sign the other fields and save changes.

This is possible?

I need do this because i need to show in my form library view the authorized field.

Hello,

Did you try using OnAfterChange event handler on the authorized field. The field is updated when the changes happen in the xml. Please read the link below.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ipsdk/html/xdevtOnAfterChange_HV01021366.asp

Thanks for the advise, i did change of the field on ip but cant change the database field.
my code:
//*****Execute Signature wizard*********///
XDocument.UI.ShowSignatureDialog();
///////////////////change ip field after sing//////////
XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SolicitudesMS/@authorize").text="1";
///////change database field//////
var objADOAdapter;
var id=XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SolicitudesMS/@id").text;
objADOAdapter = XDocument.DataObjects("sample").QueryAdapter;
objADOAdapter.Command='execute "SP_AUTORIZA" ' + id;
objADOAdapter.Command.Execute;
//////////send to mform library-------->
var oXDocument2= XDocument.DataAdapters("SendToSP");
oXDocument2.Submit();
////////////

This is executed without problems, but my database field never is updated why??.
I never get a message error.

Well, i got a solution
if u´are working with signed forms, form library and sql database and you need change some field in the Document after u're sign the form and save this change to datasources do the nex code:

function XDocument::OnSign(eventObj)
{

var Signature = eventObj.SignedDataBlock.Signatures.Create();

Signature.Sign();
eventObj.ReturnStatus = true;

if (XDocument.IsSigned)
{
XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SolicitudesMS/@autorizado").text="1";

var idsolicitud=XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:SolicitudesMS/@idsolicitudesMS").text;

try
{

XDocument.QueryAdapter.Command = 'execute "sp_autoriza" ' + idsolicitud;
XDocument.Query();

var oXDocument2= XDocument.DataAdapters("Enviar a SP");
oXDocument2.Submit();
}
catch (ex)
{
Xdocument.UI.Alert(ex.description);
eventObj.ReturnStatus = false;
}
}
}

the master tip for execute the sp is include the sentence:
SET IMPLICIT_TRANSACTIONS off