-----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? Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAk26zjQACgkQYH1+F2Rqwn0a0QCfVjdrVqk1uEEgQNNCM9E2ki// Q14AniP7vOyImvyAl4+UqbVPwMmWNAcc =N9zh -----END PGP SIGNATURE-----