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_xdelete()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
N_XDELETE()
Delete current row in current table

Syntax
N_XDELETE()

RDD
Use DELETE or DBDELETE()

Returns
True if successful. False on failure. Use N_XERROR() to get an error code.

Remarks
If no table or view is open in the current area, or if the row pointer is 
positioned at N_XEOF() or N_XBOF() then no action is taken.

Note
You cannot recall a deleted record in a table as you could in a DBF.   Once 
you delete it, Btrieve recycles the space for a new record. You may want to 
prompt users for an "Are you sure?" message before deleting.

After you delete the record, RaSQL makes the next record in the table 
current.   If you deleted the last record in the table then RaSQL makes the 
prior record current.

Example
* Delete patient record with specified ID
N_XUSE('patients')
IF N_XSEEK(PatientID)
  N_XDELETE()
ENDIF


See Also: N_XDELSKIP() N_XZAP()

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