Hi,

I am trying to convert a report which was developed in C++ (PS format) to IBI report. This report has been implemented with lot of calculations, the report data will be fetched by a SQL query based on certain criteria and will be dumped into a temporary Vector/Array List for further validation/calculation (TAX) and updates the same data into Vector/Array List. Finally the report will be generated from the latest data available in the Vector/Array List.

So, when I start converting the existing report into IBI report, I am facing lot of problems - in particular, to keep the data temporary and use them for calculation, etc.

The major problem is when I run through a Vector (xyz) that performs some calculations, the calculated data is being updated into another Vector, this is stopping me from going further; basically, would like to know:
- how to update other hold files while performing operations on a particular hold file.
- how to get data from other hold files at any point of calculation on a particular hold file.
- how to recursively use the temporary hold files like,
Hold file A ->calls-> Hold file B-> inserts C and updates D-> etc etc.

Kindly do suggest the best way to implement the same.


Thanks in advance,

Regards,
Kani

Raj,
generally, hold files are kept in a temporary directory under \edatemp\. (the name of the directory will correspond with the session number...this is called "agents") that directory dies when your entire program has finished. You can name your hold files anything you want....e.g. HOLD1 HOLD2 HOLD3 HOLD4... and your procedure, or fex, can create them and then read back from them, or update them, as long as they exist...which means as long as the procedure is active, eg, the agent is active; you can save any of these files, or just the final one, as permanent files which you write to some place you explicitly designate.
TABLE FILE CAR
..do something
ON TABLE HOLD AS HOLD1
END
TABLE FILE CAR
..do something else
ON TABLE HOLD AS HOLD2
END
TABLE FILE HOLD1
..do something small on this extract file
END
..etc
then when your fex has completed, the hold files disappear.
any help?
here's another thread on the subject
https://forums.informationbuilders.com/eve/forums?a=tpc&s=1651093421&f=7971057331&m=3281020531&r=1791012041#1791012041

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