Jimmy Rishe - All Comments

re: A mutually exclusive radio button in a repeating section

hemendraagrawal — Mon, 06 Aug 2012 09:03:13 GMT

Hi Jimmy,

I have implement same and it is working fine in client but it is not working with browser based form.

Is there any change to make available for browser based form?

re: Programmatically adding rows to repeating sections

SPowell — Mon, 28 May 2012 20:10:30 GMT

I LOVE YOU.

THANK. YOU.

re: Using DBXL with existing data - Other approaches

DC-jeff — Thu, 11 Aug 2011 22:05:26 GMT

Jimmy -

This makes total sense from the database perspective but I'm trying to figure out how this is handled from the UI perspective. For example, a document is submitted to DBXL resulting in a new record in the database. The document is then available via DBXL (and possibly SharePoint) if further updates to the document and database record are required. How can this same functionality be achieved for the "legacy" records not created within InfoPath & DBXL. How can those records be presented via InfoPath for user edits when no document exists yet?

thanks

Jeff

re: Saving Forms as New to DBXL

Patrick Halstead — Thu, 12 May 2011 08:55:23 GMT

Hi ZhenYuan and sorry for missing this. If you are using qRules, we have a command called RemoveDBXLPI which will also do this.

re: Saving Forms as New to DBXL

ZhenYuan — Thu, 09 Dec 2010 02:57:52 GMT

Hi Jimmy,

I tried using your code method but my forms are still submitted as a new version instead of as a new docid. I placed the code below on my form's loading event and then opened a submitted form from DBXL and resubmitted the form. The end result was the newly submitted form was submitted as a new version of the original docID. Did I miss out anything?

My code:

Dim piXPath As String

Dim pi As XPathNavigator

piXPath = "/processing-instruction()[name() = 'QdabraDBXL']"

pi = Me.MainDataSource.CreateNavigator()

Try

pi.SelectSingleNode(piXPath, Me.NamespaceManager).DeleteSelf()

Catch delDOCID As Exception

Return

End Try

re: Using qRules' SaveToSharePoint Command Without SharePoint

Mel Balsamo — Wed, 22 Sep 2010 14:48:11 GMT

For instructions on how to use the SaveToSharePoint command with your SharePoint server, refer to the document found here:

www.infopathdev.com/.../entry59151.aspx

re: XPath's confusing not() function - inverting a boolean field

jerkham — Wed, 30 Jun 2010 04:26:42 GMT

While this is a fairly simple concept, it's not intuitive. Very glad to find this information. Thanks!

re: Using qRules' SaveToSharePoint Command Without SharePoint

ErnestoM — Wed, 23 Jun 2010 14:24:04 GMT

If you are using IIS 6.0, check out Jimmy's follow up blog entry:

www.infopathdev.com/.../webdav-security-and-webdav-on-iis-6-0.aspx

re: Executing a stored procedure with OUTPUT parameters

Jimmy — Mon, 30 Nov 2009 05:32:08 GMT

Hey sasyregak,

Sorry for not responding to your post until now. I don't get notifications about comments on my blog posts and the easiest way to get a response is to open a new forum post.

It sounds like you are trying to use this technique on your main data source. InfoPath performs schema validation on the main data source and an operation like this that returns a schema other than the expected one will cause that error.

Might you be able to try this technique on a secondary data source?

Social comments and analytics for this post

uberVU - social comments — Fri, 30 Oct 2009 16:56:24 GMT

This post was mentioned on Twitter by InfoPathDev: Blog: Executing a stored procedure with OUTPUT parameters in InfoPath - http://su.pr/7WfE2W

re: Programmatically adding rows to repeating sections

NashParrot — Thu, 29 Oct 2009 12:26:58 GMT

I'm using this strategy for repeating sections, very succesfully. It is based on a multi-select list. I need to assign a value contained in that section (row) but don't know how to select the newly created section in order to get to the field. Any ideas?

re: Executing a stored procedure with OUTPUT parameters

sasyregak — Fri, 28 Aug 2009 13:02:54 GMT

Further after trouble shooting....I am able to find the output of the query in query analyser giving rise to a date value(single).

But the preview on infopath given the following error

The query cannot be run for the following DataObject: Report connection

The XML data returned from the data source does not match the XML Schema for this form. This discrepancy might be caused by the data source returning multiple rows when InfoPath expects only one.

Element '{schemas.microsoft.com/.../dataFields}row' is unexpected according to content model of parent element '{schemas.microsoft.com/.../dataFormSolution}dataFields'.

Expecting: {schemas.microsoft.com/.../dataFields}FileGeneralInfo.

Appreciate your help on this.....

re: Executing a stored procedure with OUTPUT parameters

sasyregak — Thu, 27 Aug 2009 12:46:04 GMT

Jimmy

Thanks for your tips... I was stuggling to get this achieved.

/ Get the default SQL command for the form.

var strOrigSQLCommand = XDocument.QueryAdapter.Command;

//Find the value of the filter criteria

var strInspectionValuationhistory = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:queryFields/q:Inspection_Valuation_history");

var strvisit = strInspectionValuationhistory.selectSingleNode("@Which_visit").text;

strvisit = strvisit - 1; //store the previous visit value

if(strvisit != "")

{

strpreviousvisitSQLcommand = "DECLARE @Previousvisitdate datetime " + " EXECUTE test " + strvisit + " ,@Previousvisitdate OUTPUT " + " SELECT @Previousvisitdate as previousdate";

}

XDocument.UI.Alert(strpreviousvisitSQLcommand);

XDocument.QueryAdapter.Command = strpreviousvisitSQLcommand;

XDocument.Query();

//Here i need to get the result stored in a global variable , so that i can refer in any other view whereever required.......please guide me

XDocument.QueryAdapter.Command = strOrigSQLCommand;

XDocument.Query();

re: A mutually exclusive radio button in a repeating section

Alec Pojidaev — Wed, 26 Aug 2009 15:47:08 GMT

You might be intersted to look at my alternative solution. To compare ...

alecpojidaev.wordpress.com/.../a-mutually-exclusive-check-box-in-a-repeating-section

re: Automatically adding rows to repeating sections

tfiema — Mon, 11 May 2009 13:22:42 GMT

To explain the non-browser form issue: The ExecuteAction method is only available in the client side Microsoft.Office.Infopath.dll (the 59KB one).

The server side one (47KB), the one referenced by forms services doesn't have this method. Meaning browser based forms cannot use this code. For browser based forms you'll need to clone a row, or do an appendChild. Either way thise seem to work only if there is already a blank row in the table (of course you need one to clone).