I have a routine that exports data to a table using a select statement.
After exporting this file I am unable to access it until after my application closes, even closing the form does not release the file.

If I view the file in windows I see that the file size is 0 kb until after the application is closed. Once the application is closed then the file has a size of about 46kb.

How can I force it to write that table out and let it go.

I have tried
Use in (lcTable)
Close tables all

With no luck.

My export code looks like this:

Select Games.Comment As game_com, Games.game, Plays.*;
FROM compusports!Games INNER Join compusports!Plays ;
ON Games.gamenum == Plays.gamenum;
where games.game == (lcGame);
ORDER By Plays.gamenum, Plays.playnum;
into table (lcTable)

where lctable is a variable like “c:\codemine7\ezscout\data\export\sample.dbf”

I need to be able to access that table without exiting the application and re-opening.