Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 'File Not Open' when issuing a Close Database
Message
De
08/06/1998 13:49:30
 
 
À
08/06/1998 13:42:28
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00105949
Message ID:
00105955
Vues:
31
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform