On 29-04-2011 16:41:56 +0200, Stefan de Konink wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Op 28-04-11 21:57, Fabian Groffen schreef:
On 28-04-2011 20:23:53 +0300, Vassilis Papakonstantinou wrote:
Hello all,
Is there a way to take the number of rows affected by the last statement just like @@ROWCOUNT in SQL Server or SQL%ROWCOUNT in Oracle?
No, you can only get it if you retrieve it e.g. through JDBC or the corresponding mapi function. It is sent to the client as part of the answer, and only known at that time.
Can't we implement it like I did for lastid? I don't know how many products depend on it, but setting an environment variable after each query doesn't sound that difficult?
lastid is available only in the same way, or is there something more to it these days?