f2s_end_buffered_save¶

Applies to: Oracle, MS SQL

Syntax

f2s_end_buffered_save {FileName}

Description

This command indicates the end of the extended record buffer and forces a save of any data currently in the buffer.

Example

SQL Server Code to create a Save Buffer.

Integer iCount
Open "SALESPERSON.int" as SALESPERSON
BEGIN_TRANSACTION
    //Set the MAX_ROWS to 100
    f2s_begin_buffered_save SALESPERSON.File_Number MAX_ROWS 100

    //The 1,000 records will be recorded in blocks of 100 records each (10% of the total).
    For iCount from 1 to 1000
        Move iCount to SALESPERSON.ID
        Move ("Name" + Trim(iCount)) to SALESPERSON.NAME
        f2s_buffered_save SALESPERSON.File_Number
        Showln 'Saving Record: ' iCount
    Loop
    f2s_end_buffered_save SALESPERSON.File_Number
END_TRANSACTION
Showln 'Finished ...'
Inkey PageEnd

Related Commands

• f2s_begin_buffered_save

• f2s_buffered_save

Replaces: Command SQL_SAVE_BUFFER_END