How to get a teamp tabe value in calling screen

[philippoommen1]

Hi,

One of our existing screen x.w is calling y.w. In x.w we are defining a New shared temp table and y.w will populate that temp table since it is a shared temp table in y.w . Once the user Save and close y.w , temp table updated records gets displayed in a browser of x.w.

Now we are in a situation where we cannot define a shared temp table or input-output param. With out these how I will get the value of the temp table in x.w once the user save and close the window y.w. All these because user can open multiple sessions of x.w and y.w at same time.

Publish/Subscribe method can accomplish this?
TIA
-Philip

 

[jdpjamesp]

Publish Subscribe will not work as each version of x.w would update each version of y.w. Don't use shared temp tables anyway. They're a nightmare. x.w and y.w should have the temp table defined identically (use some icode for this). Then x.w calls y.w with the temp table as an input-output parameter. That way each instance of the temp table is encapsulated to the current set of windows.

 

[tamhas]

Or, better yet, put the temp-table and all its handling logic in a persistent procedure and call methods on the PP instead of passing the TT around.

 

[jdpjamesp]

Indeed - I keep forgetting that option

 

[rzr]

Now we are in a situation where we cannot define a shared temp table or input-output param

Is there a reason why you cannot define input-output params?