InfoPath Dev

InfoPath doesn't support this out of the box. You can write custom code for this or use a third party tool (like DBXL web services or qRules).

I am getting an error on my data because it looks like I am loading records. My SQL database is a secondary data connection there are no query fields, so I am filtering on the field. All works well ( a little slow) in preview but when I publish to sharepoint I get an error. Is there a workaround. I do not write code so looking for a solution ...

Yes that is exactly what I'm talking about I can connect to my database and table but I want to send a parameter and get one record out without the form loading all the records I'll put a post out see if anyone can help.

When you creat a new form you have to select Database.  This will allow you to connect to the database and query the tables.  When creating a new form select File --> New --> Advanced Form Templates --> Database.  If you are speaking about adding a secondary data once you have created a form and then querying it, ...

I found it... Part of the codes come from this site http://social.msdn.microsoft.com/forums/en-US/sharepointcustomizationlegacy/thread/403e6f25-ff23-472c-b414-c17866607181 Just if someone is looking for this my codes look like this:   // Get the name for the InfoPath titlestring selectedXMLFile = ...

I am connecting to a single sql database but I cannot pass a parameter to the database - I'd like to query the database but there are no query fields.

Thanks, Jim - that's what I was wondering as I was thinking about this earlier - I'll mention that to the MS resource we've been emailing with.

When an InfoPath form with code is pubished to SharePoint, the form's code assembly is checked that it is compatible with the Sandbox.  The checks involve reflecting over the dll and making sure no calls to restricted APIs are being made.  The QRules dll, having much more code than the simple test will take longer to ...

[quote user="burepallisri"]can you please check with the attached form itself you will come to know the issue.[/quote] You haven't yet attached a form with the changes Hilary and I suggested.

 Hi,  I'm using Sharepoint Foundation (therefore no form services). I'd like to enable one person in our small company to open infopath forms in our shop to enter inspection data. I don't need great mobility, but a tablet will make her job much easier.  I loaded a free trial of Formotus and it works great, but I ...