FILEFLEX API REFERENCE



NAME
DBZapRecs -- Delete and pack a set of records

SYNTAX
DBZapRecs(start-record, end-record)

CATEGORY
Updating Information

DESCRIPTION
THIS FUNCTION HAS CHANGED IN FILEFLEX 3.0

You use the FileFlex DBZapRecs function and supply two comma-delimited values to indicate the first and last records to be deleted as arguments. The records are physically deleted and the database compacted. This makes the records unretrievable by any means.

Type the following line, supplying your own record numbers, to carry out this one-step record deletion:

put DBZapRecs(9,23) into dbResult

Note that even if you want to delete only one record, you must supply two arguments. To delete record 23, then, you would use:

put DBZapRecs(23,23) into dbResult

FileFlex now optimizes memo files associated with the packed database. In previous versions, when a record was deleted in a memo file, the data was retained in the file. The current performance is yet another benefit from the conversion from the dBASE III format of FileFlex 2 and earlier to the FoxPro format of FileFlex 3.


SEE ALSO
DBPack, DBDeleteRecs

INTERNAL FUNCTION NUMBER
17


Copyright © 1992-1998 by David Gewirtz, under license to Component Enterprises, Inc.
Contact: info@component-net.com

Casa de Bender