I am very new at this. I am trying to save a snapshot od data to a file via a fex, that would run a night. Then during the day the users would call a fex that would pull from that file.

What command should I use to save the file and then what command do I use to call it.

I have tried this command

ON TABLE SAVE FILENAME
'baseapp/invoice_detail_daily_summary_week.ftm'

which does sabe the file but this command does not call it.

TABLE FILE 'baseapp/invoice_detail_daily_summary_week.ftm'

What file type would be best to use.

This message has been edited. Last edited by: Jay Potter,

Check out "APP ..."

Are you sure you want to save an FTM file. Do you have a master for it ?

I would suggest a FOCUS file, then you can index appropriate fields for performance reasons.

Thanks for the suggestions. I ended up using the following commands within my fex to save my table.

This at the beginging of my report:

APP HOLD BASEAPP

and this inside the report.

ON TABLE HOLD AS &WEEKLY_DETAIL_FILE_NAME_THIS_WEEK FORMAT FOCUS