SQL Database Integration

Re: Disable Infopath warning - Large amount of data..

Yuraj — Tue, 10 Jun 2014 16:14:47 GMT

Hi,

I also have the message displayed when data filter is large. But sometimes when i click of continue button i get the below error message.

"The form cannot be filled out because of an error in the form's design. Contact author of the template to resolve the issue."

Is it because InfoPath has a upper limit to no. of records filtered.

Thanks,

Yuraj

Re: Disable Infopath warning - Large amount of data..

Clay Fox — Mon, 07 May 2007 15:35:02 GMT

This is the built in feature that the article describes and I do not believe there is anyway to override it. Your only option is to create your form so that the user does not experience it. Also even if you eliminate the message, the user is still having to wait a while for their information to load.

You could reduce the size of your query and avoid the message. I will assume you have already made your query as effecient as possible.

I believe this only occurs on database forms, so the best option is to rearchitect and use web services. These give you more flexibility and options when interacting with the data. You might want to look at the Database Accelerator product. http://www.qdabra.com/proddetail.asp?prod=QDBXL1

It gives you a whole suite of webservices in one package and can typically meet the needs of your form solution right out of the box. This can save you a ton of time setting up a form to submit to SQL.

In the past I had solutions where users from time to time did want lots of data from a database connection and had to live with the message, but now I would use DBXL.

Let us know if you find out any other options.

Disable Infopath warning - Large amount of data..

mortenw — Mon, 07 May 2007 09:29:22 GMT

Dear community,

A MSDN technical article on Infopath2007 says:"InfoPath 2007 has added several features to help improve the experience with
data connections:The UI enables the end user to cancel the query if it is taking too long to execute."

The message is:"The query returned large amounts of data and rendering your form may take some time.
Do you want to continue?" (Yes / No)"

My question is: Can I disable this message? and how?

All help will be appreciated - thanks in advance.