Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Sergey Karimov
  Where is Sergey Karimov?
 Reston
 Virginia - United States
 Sergey Karimov
 Tags
Subject: RE: FLUSHing properly keeps the "crap"...
Thread ID: 50364 Message ID: 50776 # Views: 5 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Monday, September 06, 2004 8:17:08 AM         
   


> Eric, it looks like
>
> FLUSH &&write changes to disc
> FLUSH FORCE &&write changes to disc, please, please write
>
> Regards,
> Sergey

Maybe it's better if I post the help topic? Not sure if that gives you more info...
----
Saves table and index changes to disk.

You can use FLUSH to explicitly save to disk all changes that you make to all open tables and indexes. You can also save changes to a specific table by specifying a work area, table alias, or path and name of a currently opened file.

FLUSH [[IN nWorkArea | cTableAlias] | [cFileSpec]] [FORCE]

Parameters [IN nWorkArea | cTableAlias] | [cFileSpec]

Specifies the work area number, table alias, or the name of a currently opened file name, for example, an index file or a file opened using the FOPEN( ) function. When specifying a file name, include the path, for example, C:\MyApp\MyTable.dbf.
Note:
If you specify cFileSpec, only changes to the specified file are saved unless cFileSpec is the name of a table (.dbf) file in which case FLUSH applies to the table memo (.fpt) file and all open indexes for that table, even if the table is open in another data session.

If you do not specify nWorkArea, cTableAlias, or cFileSpec, FLUSH applies to all open tables and indexes in the current data session.

FORCE
Calls the Windows API FlushFileBuffers function for all affected files but does not apply to temporary files and files opened as read-only. For more information, see the MSDN online documentation.

Remarks
Visual FoxPro automatically saves changes to disk when performing the following operations:

*Closing a table using the USE, CLOSE ALL, or CLOSE DATABASES command. Only the information for the file or files you close is saved to disk.
* Unlocking a record or file. Only the information for the unlocked record or file is saved to disk.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

ENTIRE THREAD

Using FLUSH Command Posted by Costas Loizou @ 9/1/2004 8:42:27 AM
RE: Using FLUSH Command Posted by Paul Brown @ 9/1/2004 9:41:50 AM
RE: Using FLUSH Command Posted by Costas Loizou @ 9/1/2004 11:40:52 AM
RE: Using FLUSH Command Posted by Pete Sass @ 9/1/2004 11:44:24 AM
FLUSHing properly keeps the "crap" down! Posted by Ken Blum @ 9/1/2004 4:52:42 PM
RE: FLUSHing properly keeps the "crap"... Posted by Sergey Karimov @ 9/2/2004 1:36:19 AM
RE: FLUSHing properly keeps the "crap"... Posted by Eric den Doop @ 9/3/2004 8:33:04 PM
RE: FLUSHing properly keeps the "crap"... Posted by Sergey Karimov @ 9/4/2004 1:30:19 AM
RE: FLUSHing properly keeps the "crap"... Posted by Eric den Doop @ 9/4/2004 2:25:02 AM
RE: FLUSHing properly keeps the "crap"... Posted by Sergey Karimov @ 9/5/2004 5:27:09 PM
RE: FLUSHing properly keeps the "crap"... Posted by Eric den Doop @ 9/6/2004 8:17:08 AM