Hi All,

I have a call string which returns a variable and I'm holding it in a table.
Then I'm calling another procedure(Main RPC) and holding it in another temp table.

When i'm trying to print values, I'm using second table to print values, but i need one value to be passed from my first table. I don't want to join the tables. Can I pass the value from first table to second one. Can anyone help me out. Thanks

This message has been edited. Last edited by: Kerry,

-READ the variable from First Table.

Assign it to any Dialog Variable &XX

Then assign the Same to a virtual DEFINE Field in Second Table.

If The column is going to have more than one distinct values, You need to do some manipulation with -REPEAT as well.

When you are taling about tables, are these separate WebFOCUS Calls, or in the same procedure.

If the other prodecure -INCLUDED or EX'ed ?

Ramkumar,

Do a search for the terms SAVE and READ and you should find plenty of information on how to accomplish this.

Dan

Waz,

These are seperate Webfocus calls(RPC calls).
In the 1st table, the values are coming from 1st RPC and 2nd table, the values are coming from 2nd call.

I think that you have two options.

1. Use FOCCACHE, you could hold the value in a temporary table. These exist for the session, I thin be default they expire after a day.

2. Create a hidden field in the first report that holds the value, this will be passed back to WebFOCUS as an amer variable.

[Solved]It got solved. I used READ and SET to accomplish this. Thanks for your help.
Enjoy Webfocussing......