Concept Framework 2.0 documentation Contents | Index

ADODataSet.Update

Name Type Access Version Deprecated
Update function public version 1.0 no

Prototype:
public function Update();


Description:
Performs a positional update 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 an "update" query. Positional operations are sometimes dangerous to the data integrity.

Example:
	...
	DataSet.CommadText="select * from my_table";
	DataSet.ExecuteQuery();
	...
	//-----------------------------------------------------------------//
	DataSet.FieldValues["my_field"]="my new value";
	DataSet.Update();
	//-----------------------------------------------------------------//
	// is equivalent with
	var current_id= DataSet.FieldValues["id"].ToNumber();
	DataSet.CommandText="update my_table set my_field=\"my new value\" where id=$current_id";
	//-----------------------------------------------------------------//

Returns:
This function returns null.

Documented by Eduard Suica, generation time: Fri Jan 21 18:06:14 2011 GMT(c)2011 RadGs Software