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

Question

Question

Stored Procedure Firing immediately when condition is not met.

Forms
Updated April 8, 2015
asked on April 8, 2015

Forms 9.2.0

I have a form that is set to run a stored procedure lookup when an id field is filled out and fills out a few other Drop down fields from the results.  Now everything works fine when the ID Is populated with a valid number, but it seems its also running immediately when the form is opened.  This is clearing out the values I have in the dropdown boxes.  I'm not sure why the stored procedure is ignoring the "Wait until this field has a value" part, but I've seen a couple other posts with similar issues but the response was that it shouldn't run right away when the field is blank.  Any help would be greatly appreciated, thanks.

0 0

Answer

SELECTED ANSWER
replied on April 8, 2015

This is a bug in Forms 9.2. On form load, lookup rule will be triggered to see if the criterion field has default value and then fill the target field. But if the criterion field has no value, it will still trigger the rule, which is not expected.

This should be fixed in next release, sorry for the inconveniency.

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...