DBRESULT

9.0, PLBCMP GUI or PLBLinux Only

The DBRESULT instruction obtains the number of rows affected by a DELETE, INSERT or UPDATE SQL operation. The instruction uses the following format:

Where:

label

Optional. A Program Execution Label.

db

Required. A DBFILE or DBSTATEMENT variable defining the database associated with the connection.

result

Required. A previously defined Numeric Variable that receives the value.

Flags Affected: OVER, ZERO

Note the following:

1. If the {result} is zero, the ZERO Condition Flag is set.

2. If {result} is too small to contain the value, the OVER Condition Flag is set.

3. If the SQL operation is not a DELETE, INSERT or UPDATE, the {result} value is indeterminate.

See Also: Example Code, SQL Instructions