InfoPath Dev

Hi,  I'm trying to copy a table from a secondary data source (populated using DBXL GetColumnsXMLStrQuery) from a SQL datatable into a repeating table in the main data source.  When I right click on the group just before the repeating node, this is my XPath: ...

Thanks Patrick.  I'm using the on demand method, with lots of help from Hilary's previous blog on this topic.  It works really well. Related to that, I'm wondering if you could help me with an issue.  I found your sample paging example, and it looks like it's a pretty simple and elegant solution.  What I'm ...

I'm sure this has been answered before, but I guess my search isn't giving me what I need to know. Is there a method that exists in DBXL that allows a form to retrieve data from existing SQL tables, then conversely update the data if it changes?  For example, we have a SQL table of existing IT employees with various personal data ...

It works when I use buttons and physically supply the form name.  I checked against the library and it checked out under my name as well.  The UDCX files are under the Facilities collection, not the eForms collection.

It loads the form and then throws the error again.

I changed the data connections to be relative to the site collection and am now getting the correct path, verified by a calculated field.  However, now I'm getting this error: The following query failed: CheckOutFile (User: , Form Name: CapitalRequest, IP: , Connection Target: ...

Ok, new developments: I tried applying the same methods using the same UDC files in another library and get different results.  Here's what I'm encountering: The formula for the form URL returns correctly in the test form I generated.  However, in the production form I'm trying to duplicate this in, I get different ...

Ok, I think I've got it now.  The piece I was missing was the data connection back to the library and pulling the Checked Out to property.  Once I had that in place, all kinds of things open up now.  I can correctly identify when it's checked out and who has it. Thanks again.

A couple of things, the UDC files were using a Secure Store Service to utilize a machine account.  This apparently was circumventing SP security, at least from identifying the current user.  I removed this for the check out and in UDC's and I'm now getting unique users on checkout. I just found your blog on auto check out and in ...

Thanks, I know my answers can be a bit "fast forward" and I apologize. Yes, I'm using the formula as you noted, and it's now retrieving the correct URL.  I wasn't populating when pulling the form from the library. The issue now is the XML is always being checked out to me, even if somebody else opens.  So, in that ...