General information
Title:
Cannot access table
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only