Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (9 items) Re: Submit to "SQL Server" a digitally signed form I think I found the reason why signed forms cannot be submitted to a database. If you use Web services, in one of the Data connection wizard windows, there is a check box that reads:Submit data as string. Note: Digitally signed data must be submitted as a string to preserve white spaces. This means that during the submit process white spaces are ... Posted to SQL Database Integration (Forum) by josera on 01-11-2011 Remove digital signatures programmatically Hi, According to the documentation, the way to remove the digital signatures is this (in VBScript): dim a set a = XDocument.SignedDataBlocks("BuyerSection").Signatures(0).SignatureBlockXmlNode a.parentNode.removeChild(a) set a = nothing It executes without any warning nor message, but on the screen the data is still locked. ... Posted to Code (Forum) by josera on 01-08-2011 Re: Using Visual Basic code to execute stored procedures in SQL Hi Zhen Yuan, the previous DB access command is the one that you defined when you selected Database as the main data source. It is used by your form to retrieve and store data from/to the main source database. If you don't need to do any further retrieve or restore operation after you run the stored procedure, then you do not need to ... Posted to SQL Database Integration (Forum) by josera on 01-08-2011 Re: Using Visual Basic code to execute stored procedures in SQL Hi ZhenYuan, I use VBScript instead of Visual Basic but perhaps this can help you because of the similarities. This is what works for me to run a stored procedure from Infopath 2007 in SQL Server 2008: ' Run the stored procedure [UpdateModifiedDay] in the DB dim cn set cn = ... Posted to SQL Database Integration (Forum) by josera on 01-07-2011 Submit to "SQL Server" a digitally signed form Hi, I use Infopath 2007, VBScript and "SQL Server 2008". My forms are digitally signed and at the end of the process they are saved and I also need its data to be stored in the database. The form contains the signature of three different people and when the third signature is done, the form is saved and then the data should be stored in ... Posted to SQL Database Integration (Forum) by josera on 01-07-2011 Re: Navigate through the fields in a repeating table Thanks Patrick for your contribution. My form is based on SQL Server and Infopath forces me to use the data structure that it generates. This data structure is built on attributes so I don't have a choice. This is just a particular case. What I wanted to know is the way to navigate through the same line in a repeating table. I ... Posted to Code (Forum) by josera on 12-13-2010 Navigate through the fields in a repeating table Hi, In one field of a repeating table, the user selects a date with a date picker. With the date I calculate the week of the year and I write it in other field of the same line of the repeating table. I am using VBScript. @Day is the date picker and @WeekOfTheYear is the destination field. I get to @Day attribute node with eventObj.Site so I ... Posted to Code (Forum) by josera on 12-06-2010 Re: Cannot access information across domains error To remove the error go to Internet Explorer > Tools > Internet Options > Security tab > Click Internet zone > Click Custom level... button > in Miscellaneous/Access data sources across domains click Enable. Hope it woks for you. Please tell us. Posted to SQL Database Integration (Forum) by josera on 11-29-2010 Cannot submit programmatically to SQL server Pretty desperate here. Please help. From a first form I open a second form programmatically. All operations on the second form are done programmatically. These operations are: Open the second form Fill out the form Submit it to its "SQL server" DB But I get this message: InfoPath cannot submit the form. The form does not ... Posted to SQL Database Integration (Forum) by josera on 11-01-2010 Page 1 of 1 (9 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.