Caravan Business Server>Help>Database>Deleting records |
Syntax
|
<caravan>table connection instance name(deleterecord)</caravan>
|
Text
|
To delete an entire record, first position the current record pointer recordno to the record you want to remove, then use the deleterecord keyword. The record number may be passed from a form or may be a constant . The syntax is as follows.
|
Sample
|
Form field
<caravan> table contacts = contacts.contacts contacts(recordno)=form(recno) //form(recno) is the record number passed to the current web page by post method from a previous web //page. contacts(deleterecord) </caravan>
Constants
<caravan> table contacts = contacts.contacts contacts(recordno)="3" // go to record number 3 contacts(deleterecord) </caravan>
Deleting a record set based on search condition
<caravan> table contacts = contacts.contacts select from contacts where company=1 and firstname=john and lastname=minolta contacts(deleterecord)
</caravan>
|
Back
|