InfoPath Dev

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???

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, ...

loma, i hope this can help you 1.create a webservice that return a dataset with data of the current user(name,mail, department, etc) 2. Create a secondary datasource to your webservice. 3. Query u'r secondary datasource and get data from the fields. Regards,

try this: Put a button control, go to properties and edit code, put the next code(jscript): XDocument.DOM.selectSingleNode(''/myFields/ID'').text = Math.random()*1000;

ok, i try to translate the error message: ------------------- InfoPath can´t send the form. Error sending the form. Error after send succesfully the changes to data source. Must save and close the form before continue This value has been signed digitally and can not be changed. -------------------- InfoPath can´t send the form [Microsoft Cursor ...

Scenario: I have a Trusted Form in a form library with datafields and a signature button. I need the next functionality in the button code: a) set a field a value=1 b) Sign the form c) save data to my main Connection and send the form to the form library. I write this, but ip send me a error message: function XDocument::OnSign(eventObj) { var ...

Maybe, u can use this code: var value = Math.random()*1000; regards,

Well, i have a solution. 1. First i have to work with database connections because is more easy deal with it. 2. i have to write some code: a) setup my secodary data source (database) var Solicitudes = XDocument.DataObjects(''CatSolicitudes'').DOM Solicitudes.setProperty(''SelectionNamespaces'',... b) depending of selected data, ...

Scenario: I have two ip forms A and B, in A form i have a id field and a repeating table with n items. <ID>1</ID> <RT> <Requierements>X</Requierements> <Requierements>Y</Requierements> </RT> In form B i have a field id(Combobox) with reference to the ID from the form A(Secondary ...

i have the same problem, did u find a solution???