Update files

Syntax

Update files ([Do not cancel pfu])

Options

Description

This command writes the records in the current record buffer to disk and cancels the Prepare for... mode. You must execute the command when Omnis is in a Prepare for update mode otherwise an error occurs.

If a warning error code kerrUnqindex or kerrNonull is returned during the execution of this command, the Prepare for update mode is not canceled. This means that you can check for these errors and recover without losing the data the user has already typed in. In fact, if you issue a new Prepare for... command, Omnis will reread records, and any data that is already in the CRB will be lost.

The Do not cancel pfu option prevents the command from canceling Prepare for update mode. Thus, you can make more changes to the data, the multi-user locks remain in place, and another Update files can be executed.

The Update files command causes the indexes in the files to be re-sorted. Thus, in multi-user mode, the files are locked while Update files is executing. You can control this file locking by running Do not wait for semaphores. When Do not wait for semaphores is active, Update files returns flag false and does nothing if the file is locked.

Example

# The following example inserts an invoice in the parent file and a list of
# related invoice items in the child file. The Do not cancel pfu option ensures 
#  that the parent record remains locked until complete. 
Set main file {fInvoice}
Prepare for insert 
Enter data 
Update files (Do  not cancel pfu)
Set main file {fItems}
For  lInvoiceItems.$line from  1 to  lInvoiceItems.$linecount step  1
  Prepare for insert 
  Load from list 
  Update files (Do  not cancel pfu)
End For 
Update files 
# In multi-user mode you can control file locking using Do not wait for semaphores, for example 
Wait for semaphores 
Prepare for edit 
Enter data 
Do not wait for semaphores 
If flag true 
  Repeat 
    Working message {Waiting for file locks}
    Update files 
  Until flag true 
End If