Thread: Returns from ExecTuplesOk()

I'm confused. In libpq++, it seems that ExecTuplesOk() should return
PGRES_TUPLES_OK if a tuples are returned from the query. Yet I'm getting
PGRES_COMMAND_OK instead. When I then check Tuples(), it returns 1. Am I
missing something?

Paul

On Sun, Apr 21, 2002 at 10:58:10PM -0400, Paul M Foster wrote:

> I'm confused. In libpq++, it seems that ExecTuplesOk() should return
> PGRES_TUPLES_OK if a tuples are returned from the query. Yet I'm getting
> PGRES_COMMAND_OK instead. When I then check Tuples(), it returns 1. Am I
> missing something?
>
> Paul

Okay, I answered this myself.

Apparently, ExecCommandOk() and ExecTuplesOk() return true or false, not
PGRES_* values. Beyond that, there is no other clue about why a query
would fail. The PGRES_* values are only returned by the Exec() function,
which you are discouraged from using, for some reason.

I read this in the docs in the first place, but dismissed it as a
misprint. Duh.

Paul

Paul M Foster wrote:
> I'm confused. In libpq++, it seems that ExecTuplesOk() should return
> PGRES_TUPLES_OK if a tuples are returned from the query. Yet I'm getting
> PGRES_COMMAND_OK instead. When I then check Tuples(), it returns 1. Am I
> missing something?

I am not sure.  Does libpq++/examples help?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026