POPULATE_GROUP_WITH_QUERY by using procedure [message #643088] |
Mon, 28 September 2015 17:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/021f0b1f10e6e12b6af60d7975584c26?s=64&d=mm&r=g) |
shumail
Messages: 149 Registered: September 2012 Location: Canada
|
Senior Member |
|
|
Hi All
I need to create a dynamic records groups that get data from my calling procedure, can someone guide me how to call procedure with POPULATE_GROUP_WITH_QUERY built...
POPULATE_GROUP_WITH_QUERY ('My_group',procedure(a,b));
Regards
Shumail
[Updated on: Mon, 28 September 2015 17:06] Report message to a moderator
|
|
|
|
|
Re: POPULATE_GROUP_WITH_QUERY by using procedure [message #643105 is a reply to message #643099] |
Tue, 29 September 2015 08:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/6f539f43889b4b3e3fcb6c591073de8f?s=64&d=mm&r=g) |
CraigB
Messages: 386 Registered: August 2014 Location: Utah, USA
|
Senior Member |
|
|
Quote:I need to create a dynamic records groups that get data from my calling procedure...
You can't use POPULATE_GROUP_WITH_QUERY() built-in like this. You need to get the SQL provided by the procedure in a Variable first, then pass the variable to the built-in. You might want to visit the Forms Help topic on the POPULATE_GROUP_WITH_QUERY() built-in for all of the rules on how to use the built-in.
Craig...
|
|
|