You are viewing limited content. For full access, please sign in.

Question

Question

Forms Lookup Rule Problem with Many Rows

asked on March 18, 2016 Show version history

Hi,

I'm trying to troubleshoot a Forms 9.2.1.1069 issue. There's a field lookup rule with no condition that says Fill [Field Name] with data source value [Column Name].  The values are coming out of a table. 

There seems to be a problem related to the number of rows in the table, which is around 16000. As the users type into that field, the form starts to "freeze" on them, and IE stops responding (it's reported Chrome crashes as well.) 

When I remove that rule, everything works fine. I've also removed all javascript with no change. The SQL error logs look very clean, and I do not see anything being reported to the machine event log, besides some IE application hangs.

I suspect the problem is the number of rows being returned, and was wondering what can be done.  The customers seem to like having the autocomplete behavior, just without the crashing.   I think if it could just return the top [reasonable number] rows, that would be much better. Thanks so much for any help and apologies if I've misinterpreted what's happening or missed a relevant article in my searching.

0 0

Replies

replied on March 21, 2016

Hi there,

You can use the stored procedure on the huge table, so that only specified amount of rows get returned. Can you tell me what kind of form is this? what value people want to look up on?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.