[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 APPEND BLANK
 Add a new record to the current database file
------------------------------------------------------------------------------
 Syntax

     APPEND BLANK

 Description

     APPEND BLANK is a database command that adds a new record to the end of
     the current database file and then makes it the current record.  The new
     field values are initialized to the empty values for each data type:
     character fields are assigned with spaces; numeric fields are assigned
     zero; logical fields are assigned false (.F.); date fields are assigned
     CTOD(""); and memo fields are left empty.

     If operating under a network with the current database file shared,
     APPEND BLANK attempts to add and then lock a new record.  If another
     user has locked the database file with FLOCK() or locked LASTREC() + 1
     with RLOCK(), NETERR() returns true (.T.).  Note that a newly APPENDed
     record remains locked until you lock another record or perform an
     UNLOCK.  APPEND BLANK does not release an FLOCK() set by the current
     user.

 Examples

     .  This example attempts to add a record to a shared database
        file and uses NETERR() to test whether the operation succeeded:

        USE Sales SHARED NEW
        .
        . <statements>
        .
        APPEND BLANK
        IF !NETERR()
           <update empty record>...
        ELSE
           ? "Append operation failed"
           BREAK
        ENDIF

 Files   Library is CLIPPER.LIB.


See Also: APPEND FROM FLOCK() NETERR() RLOCK()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson