Hi Steve,
The
USE IN command expects an alias not a table name. You can close table by issuing USE command w/o parameters right after select
Select Games.Comment As game_com, Games.game, Plays.*;
...
into table (lcTable)
USE
>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.
--sb--