Question

Collections in Forms 10.1 with stored procedures

Forms

Updated September 21, 2016

asked on September 13, 2016

10.0 I know was not properly pulling in Collections with multiple rows from a stored procedure in the database. I am seeing the same behavior in 10.1. I wanted to verify if stored procedures with multiple rows to return should be filling the collection properly.

0 0

Answer

SELECTED ANSWER

replied on September 14, 2016

I mimic'ed that and found the same result. It was the check for as new sets.

Mine were unchecked on import.

0 0

replied on September 18, 2016

For the "as new sets" was unchecked when import, I checked with 10.1, after import, the checkbox is still checked when the same data source exist. Can you still reproduce this issue if you export the process then import again?

0 0

replied on September 21, 2016

I believe the exported form from the other engineer's computer was unchecked.

So on import it was also unchecked.

He disabled the checked before exporting to me for testing but did not re-check them for me. Upon testing I was expecting it to be successful and was not. After referencing again what differences could be seen between both systems it was obvious the "as new sets" were not set.

0 0

Replies

replied on September 14, 2016

How do you configure the lookup rule? No problem for me with following lookup rule:

lookup.png (21.84 KB)

| Download

1 0

You are not allowed to follow up in this post.

Question

Question

Collections in Forms 10.1 with stored procedures

Answer

Replies

Sign in to reply to this post.