Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
anoopvj

Veteran
Registered:
Posts: 130
Reply with quote  #1 
Hey,

Is it possible to bind the result obtained by executing a Stored proc into a Grid?

Thanks
Anoop
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
You can do this by hacking the database. Personally I do not rtecommend it unless you are prepared for some pain and know exactly how to do it.

My preferences are a vierw if possible, or if not, you can fill a temporary table with the sp results.


__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
anoopvj

Veteran
Registered:
Posts: 130
Reply with quote  #3 
Thanks Jerome.
If I fill temp table using SP,
how can I bind to GRID?

HOw is possible to pass data from main form to admin form?
I'm popping up a admin form on a click of button
0
bigfootger

Veteran
Registered:
Posts: 139
Reply with quote  #4 
Hi,

I usually use cookies for this. I write it on the main form and read it on the admin form.



__________________
Metastorm BPM Remote Expert Help & Web Consultations - http://connect.convedo.com/free-1-hour-web-consultation
0
anoopvj

Veteran
Registered:
Posts: 130
Reply with quote  #5 
Yea thats correct.
But I cud set the cookie in the main form and get it back and assign to a variable in the Admin form in it onload in client side. Is that correct?
But I dont know why, i cannot set it to a variable in the Admin form on onload.

Can you gimme a suggestion?

Thanks
Anoop
0
anoopvj

Veteran
Registered:
Posts: 130
Reply with quote  #6 
Jerome My Intention is to get a Hierarchy of employees from Employee table and all the other details associated in it from other tables.
For that I had to use a SP. But as you said, if I create a temporray table from the SP, how can I bind it to GRID?
Can you tell me steps for doing that?.

Again Is it possible to show the heirarchy and the details in a drill down way in Metastorm? IF so can yoou help me out?

Thanks
Anoop
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #7 
Just use a table and insert the folder id for every associated record. Set that table for the grid and restrict it to only records for that folderid. On submitting the form, delete the records.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
erasmus

Member
Registered:
Posts: 12
Reply with quote  #8 
If you use a function instead of a stored procedure, you can have the function return a table.  Then, in the grid definition, instead of a table name, put in the function call with it's parameters (for example, GetNotes_F(%FolderID) as the table name).  You will not be able to then use the dropdowns to set your columns (so know your column names) but this hack will "bind" a function's returned table to a grid.  Cannot be editable for obvious reasons.

Not sure if this is what you were looking for, but it would allow you to do all of your stored procedure processing and return a temporary table with the results into the grid that is shown.

Also, a lot of what you described sounds like it could be done with a view bound to a grid with a dropdown for the employee name.  You could show all employees under whatever employee name is in the dropdown by having the where clause of the query compare the user's "reports to" value to the dropdown's value.

It's not a "hierarchical tree" but it shows the data.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!