ADODataSet.ExecuteQuery


public function ExecuteQuery

Prototype:

function ExecuteQuery(forwad_only=false);

Parameters

forward_only
This parameter defaults to false. Should be true only if you intend to use a MySQL table with text fields. In this case you should use FetchForward instead of First and Next.

Description:

It executes the SQL query specified by the CommandText or PreparedQuery property and updates the FieldValues property. This is suitable for "select" queries; for other queries (like delete, update, alter), you may check ExecuteNonQuery.

Return value:

Returns -1 if the connection is not set, 0 if couldn't execute the query or 1 if succeeded.