Home Contents | # sql:rowsAffected | Sql | Core4 Lua Commands

## SYNOPSIS

count = query:rowsAffected()

## DESCRIPTION

This function returns the number of database rows that were changed or inserted or deleted by the most recently completed SQL statement on the database connection specified by the first parameter. Only changes that are directly specified by the INSERT, UPDATE, or DELETE statement are counted. Auxiliary changes caused by triggers or foreign key actions are not counted.

## RETURN VALUE

Returns a number.