COMMIT
Perform a solid-disk write for all active work areas
Syntax
COMMIT
Description
COMMIT is a database command that flushes Harbour buffers and performs a solid-disk write for all work areas with open database and index files. The solid-disk write capability is available under DOS version 3.3 and above. Under DOS 3.2 or less, COMMIT flushes Harbour buffers to DOS.
In a network environment, issuing a GO TO RECNO() or a SKIP0 will flush Clipper’s database and index buffers, but only a COMMIT will flush the buffers and perform a solid-disk write. Thus to insure updates are visible to other processes, you must issue a COMMIT after all database update commands (e.g., APPEND, REPLACE). To insure data integrity, COMMIT should be issued before an UNLOCK operation. Refer to the “Network Programming” chapter for more information on update visibility.
Examples
. In this example, COMMIT forces a write to disk after a series
of memory variables are assigned to field variables:
USE Sales EXCLUSIVE NEW
MEMVAR->Name := Sales->Name
MEMVAR->Amount := Sales->Amount
//
@ 10, 10 GET MEMVAR->Name
@ 11, 10 GET MEMVAR->Amount
READ
//
IF UPDATED()
APPEND BLANK
REPLACE Sales->Name WITH MEMVAR->Name
REPLACE Sales->Amount WITH MEMVAR->Amount
COMMIT
ENDIF
Seealso
DBCOMMIT(), DBCOMMITALL(), GO, SKIP