Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- RaSQL/B 6.1a for Clipper - <b>n_xzap()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XZAP()
Delete all records in current table

Syntax
N_XZAP()

RDD
Use ZAP or __DBZAP()

Remarks
All records in the current table are deleted. Once records are deleted in ..
Btrieve, they are not recoverable. Thus, you may want to display an "are you ..
sure?" message to the user before deleting records.

N_XZAP() deletes all records one at a time. If a table contains a large ..
number of records, it may be quicker to recreate the table under a new name, ..
delete the old table, then rename the work table. For example:

N_XUSE('patients.dta', ...)
* Download definition
N_XMAKEDBF('rasql.dbf')
* Close table
N_XCLOSE()
* Create work table
N_XMAKETBL('', 'work.dta', 'rasql.dbf')
ERASE patients.dta
RENAME work.dta TO patients.dta

Example
N_XZAP()
? N_XLASTREC()
0


See Also: N_XDELETE()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson