Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

SQL.RowsAffected

Returns the number of rows affected by the last insert/update/delete command execution.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
SQL 2.6 Yes Yes Yes Yes Yes

MBS( "SQL.RowsAffected"; Command )

Parameters

Parameter Description Example value
Command The command reference number gained with SQL.NewCommand. $Command

Result

Returns number of rows or error message.

Description

Returns the number of rows affected by the last insert/update/delete command execution.
This normally only works if enabled, so please call SQL.SetCommandOption function to enable it if needed.
You may need to define cursor to be scrollable or cached in order to get number of rows in a recordset.

Examples

Requests a scrollable record set:

MBS( "SQL.SetCommandOption"; $Command; "Scrollable"; "True" )

See also

Example Databases


SQL.Rollback   -   SQL.SQLite3.EnableLoadExtension

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins