<< SciDb SciDb DbConnect >>

SciDb >> SciDb > DbAffectedRowsNumber

DbAffectedRowsNumber

get a number of rows affected by a query

Calling Sequence

DbAffectedRowsNumber(resultHandler)

Parameters

resultHandler

a pointer to object of result (returned by DbQuery())

Description

DbAffectedRowsNumber(resultHandler) gets a number of rows affected by a query.

Examples

// Opens a “PostgreSQL” connection with a connexion string
dblink = DbConnect("PSQL", ..
"Server=127.0.0.1;Database=myDataBase;User Id=myUsername;Password=myPassword;");

resultHandler = DbQuery('SELECT * FROM addressbook');

//get the number of results returned
DbAffectedRowsNumber(resultHandler);

resulthandler = DbQuery('DELETE FROM addressbook WHERE name LIKE ''Igor%'' ');
//get the number of records deleted from table
DbAffectedRowsNumber(resultHandler);

//Disconnect from default (the last) database myDataBase
DbDisconnect();

See Also

Authors


Report an issue
<< SciDb SciDb DbConnect >>