Hello,

I have field name FOCLIST/I5, I want to get maximum foclist(number) from my focus file. I cann't use the &RECORDS since I also use delete from the same file. So I have use
TABLE FILE FILENAME
MAX.FOCLIST
END
Now How can I set up the dialog manger variable equals to the number or value I got from this table request command earlier.
Do I have to hold in the file and read the hold file , How it works example of code will more helpful?

In advance Thanks for your suggestions.

yes exactly
TABLE FILE FILENAME
SUM MAX.FOCLIST
ON TABLE SAVE
END
-RUN
-READ SAVE &HOWMANY.A5
-TYPE here's howmany i have &HOWMANY
Before you start, make sure the format of your foclist file is I5

TABLE FILE FILENAME
MAX.FOCLIST
ON TABLE HOLD
END
-RUN
-READ HOLD &HOLD_FOCLIST.I5.
-* You can ref. &HOLD_LIST in Dialogue Manager or set to another Dialogue Manager variable:
-SET &MAXLIST = &HOLD_FOCLIST ;


> I hope this helps. Jim

Thanks,
For your suggestion, it worked for me.

Thanks once again.