ADODataSet.Delete


public function Delete

Prototype:

public function Delete()

Description:

Performs a positional delete on the current query. Is better to avoid the positional updates and deletes. Is recommended to use the CommandText or PreparedQuery and ExecuteNonQuery to execute a "delete" query. Positional operations are sometimes dangerous to the data integrity.

Return value:

This function returns null.

Example
	...
	DataSet.CommadText="select * from my_table";
	DataSet.ExecuteQuery();
	...
	//-----------------------------------------------------------------//
	DataSet.Delete();
	//-----------------------------------------------------------------//
	// is equivalent with
	var current_id= DataSet.FieldValues["id"].ToNumber();
	DataSet.CommandText="delete from my_table where id=$current_id";
	//-----------------------------------------------------------------//