InfoPath Dev

Welcome. So you are updating a SP list not a Document Library. Have you reviewed some of the methods here?  If you search on CAML you can find some posts. I have not done this in code. I would look at the source data, although I guess you have said that just changing the title allows it to work.  Strange. Hopefully someone else will ...

Where is the intended save location? Do you have a submit data connection for this location? Which saves the file with a unique file name to this place? All data in your Main Data Source will be saved.  The default save should probably not be used since it does not control where the user saves the XML file.  This can be turned on and ...

Hey Steve. If  SQL query works in SQL then it should work anywhere. You have three fields in your select but only one is a sum. For Group By to work you can only have one field that is not summed or have a function to it and you must group on that field.

I had a similar need for a salary timesheet. I found the script below on the internet and created a date table, then pulled the information into the form thru a lookup table datasource.  It worked great. SQL Code To insert a series of dates into a table  create table ...

Solution : http://blogs.msdn.com/infopath/archive/2006/11/08/submitting-to-this-document-library.aspx

Thanks for the quick response.  After doing some more digging around I found that I could wrapper the Sharepoint GetListItem web service with one tailored to what I was trying to pull though then simply referencing this as a secondary data source.  Was a little fiddle but it works fine now.  Cheers

Hi Everyone,  I have a real challenge...  My Infopath form posts "new items" & "updates existing items" on random but fixed records.  Say Starlink codes 105, 1104, 1109, 1140 all work, but 101, 109, 1105, 1106, 1107 do not.  The randomness appears with no pattern of records in the SP List I'm ...

 Hello everybody,  Here's my situation:  I have a .NET app using automation to work with Infopath 2003. At some point I noticed that when I change some data in my Infopath form and click on the "Save" toolbar icon the data won't persist through closing and reopening the form (that used to work normally for a ...

I have a SQL statement with a Group By clause that get the following error:  The following error occurred: The query method on the Document object failed. InfoPath cannot run the specified query. No query fields have been generated because the specified SQL statement is too complex for InfoPath to parse. Does anyone know how to code a SQL ...

First at all, thanks for your help. The first user (me) can open from my outlook and edit the data that came from the SQL database. The second user (any one) can open the form, but can't edit the data from the database. I try to publish the form in a MSI file installable, and if the second user executes the .xsn , he can edit the ...