Mike Lewis
Programmer
I am new to Postgres, so please bear with me.
I am connecting to a Postgres database via ODBC (my client happens to be Visual Foxpro, but that's not really relevant).
I would like to send an UPDATE to the server, and find out how many records were affected by the update. I see from the Postgres docs that "output" from UPDATE is the number of rows updated, which is exactly what I want. My question is: how can I get return that "output" to the client.
In SQL Server, I would query @@ROWCOUNT immediately after the UPDATE. I need to know the Postgres equivalent of that.
Thanks in advance.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
My Visual FoxPro site: www.ml-consult.co.uk
I am connecting to a Postgres database via ODBC (my client happens to be Visual Foxpro, but that's not really relevant).
I would like to send an UPDATE to the server, and find out how many records were affected by the update. I see from the Postgres docs that "output" from UPDATE is the number of rows updated, which is exactly what I want. My question is: how can I get return that "output" to the client.
In SQL Server, I would query @@ROWCOUNT immediately after the UPDATE. I need to know the Postgres equivalent of that.
Thanks in advance.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
My Visual FoxPro site: www.ml-consult.co.uk