Delete Method
Deletes the current record from a Recordset (Recordset object).
Deletes a specified file from the 'Current folder location' on the ftp server (FTP Connection object).
Recordset object
Deletes the current record from a Recordset.
RecordsetObject.Delete()
Client support
Newlook Smartclient
Newlook Server
Parameters
None.
Use
When used with the Recordset Object, the Delete method sets the EditMode property of the Recordset to EditNone if it is successful. Retrieving field values from the deleted record returns an error value. After deleting the current record, the deleted record remains current until you move to a different record. Once you move away from the deleted record, it is no longer accessible.
If you nest deletions in a transaction, you can recover deleted records by rolling back the transaction via the RollbackTrans method.
EXAMPLES
In the following example it is assumed that we are connected to an Access database, the following function prompts the user, deletes the current record and then clears the values on the relevant controls of the current form.
JSCRIPT
// Delete the current record
function deleterecord()
{
rc = App.MsgBox("Are you sure you want to delete this record?", "newlook", nlMsgQuestion, nlMsgYesNo);
if (rc == nlMsgYes)
{
Samplerecordset.Delete ();
clearrecord ();
}
}
FTP connection object
Deletes a specified file from the 'Current folder location' on the ftp server
FTPConnectionObject.Delete(Name)
Client support
Newlook Smartclient only.
Parameters
Name – (String, Required)
This is the name of the file to delete. The actual file path would be 'Current folder location\Name'.
See Also
DBConnect Method | Open Method | Disconnect Method | Close Method | Find Method | Move Method | AddNew Method | BeginTrans Method | CancelUpdate Method | CommitTrans Method | Delete Method | RollbackTrans Method | Seek Method | Update Method | ConnectionString property | FTP Connection object | Recordset Object
Applies To
© 2004-2021 looksoftware. All rights reserved.