How to return number of errected rows

Scriptcase 8 Discussion
#1

sc_exec_sql(“update table_a set name=‘abc’ where id=‘1’”);
when i execute this query how to know how many rows effected.

#2

If you use mysql you can ask for this: http://php.net/manual/en/function.mysql-affected-rows.php

#3

i’m using sc macros.

#4

Think Albert is saying that u should use SQL instead, not much of a code change then u can echo the results