| building dataset based on another dataset [message #1106815] |
Wed, 11 September 2013 11:35  |
Eclipse User |
|
|
|
Hello,
I have a dataset. I now want to build another dataset based on the first dataset (as if the first dataset was a data source). Is this possible? Can it be done in scripting? If so, what would the script look like?
If this is not possible, maybe I can do this in a single dataset with a more complex query. The query I currently have for the first dataset is as follows:
{call MyStoredProcedure(?,?)} <-- where the first ? is an input parameter and the second ? is an output parameter (SYS_REFCURSOR in the stored procedure).
What would a simple select statement look like if it drew from the results of this stored procedure call?
Thanks for all forthcoming help.
|
|
|
|
|
| Re: building dataset based on another dataset [message #1107702 is a reply to message #1106815] |
Thu, 12 September 2013 16:24  |
| Eclipse User |
|
|
|
Hello again everyone,
I've been playing around with that script that Kristopher linked me to, and I'm able to use it (or parts of it) to get the dataset I want. I'm now trying to get the values in the dataset after the query has been run (it's actually a stored procedure, but that's irrelevant). I'm not sure how to do this.
I'm also not sure what would be the best event handler to do this in as it would have to be at a point after the dataset has been filled with data. I'm thinking afterFactory, but I could be wrong.
Any help would be much appreciated. Thanks.
|
|
|
Powered by
FUDForum. Page generated in 0.03858 seconds
Home