Henry Vermaak wrote:
On 20/06/07, Joost van der Sluis <[EMAIL PROTECTED]> wrote:
You mean how many rows are affected by the last query you've run? I saw
request for that earlier.
But imho, you never need it. You always should know how many rows are
affected before you execute a query.
Of course not, what absurd nonsense.
It could be a debug-tool,
though.Maybe I could implement it. Maybe for one specific connection, or
maybe even in a general form.
you can't always know, for instance if you do a conditional update:
update programmers set overtime = 'yes' where work_hours > 80
i've never used it in a program myself, but I've noted that there's an
api function for this in mysql and there's the sql function
ROW_COUNT() (in 5.0.1). i suspect there are similar functions for
different flavours...
MySQL has mysql_affected_rows, Postgres has PQcmdTuples.
Regards,
Adriaan van Os
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal