>A real strange problem. I have a screen form where I have the use select some options for producing a report. I then select a subset of the main data table based on the user input. I then total some numeric fields to a table. Depending on report options either the subset of data or the totalled table is used for prodcuing the report.
> I then give the users the option to rerun the report with different option. I close the table of subset data and the totalled table and here is where the problem occurs. I get a 'File Not Open' error after the tables are closed.
>
> I get the error message whether I use CLOSE DATA or select each table and issue a use. The strange thing also is that if I close the table individually, when I close the SECOND table, that is when I get the error.
>
>ie
>use disp
>select *** fron disp to table curcost
>total on emp to rpt15
>report form ....
>
>** then eitehr
>CLOSE DATA
>**or
>SELECT curcost
>use
>select rpt15
>use
>** BOOM - 'Error File not open.'
>
>HELP!!! PLEASE
This construction should be safer:
if used('rpt15')
select rpt15
use
endif
Edward Pikman
Independent Consultant