f2s_end_buffered_save¶
Applies to: Oracle, MS SQL
Syntax¶
f2s_end_buffered_save {Filenumber}
Parameter |
Description |
|---|---|
Filenumber |
Number of the file (FileName.File_Number). |
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