Hi Scott,
> try
>
> declare cursor xyz as select ...
> fetch 100;
>
> and see how that works.
sorry for probably asking such a stupid question, but we are using a
PQexec(). Where should I specify that cursor declaration?
BTW: When executing
BEGIN WORK;
DECLARE "test" CURSOR FOR SELECT * FROM "TEST";
FETCH FORWARD 100 from "test";
CLOSE "test";
COMMIT WORK;
in pgAdmin III, then no data is being displayed and the following
message (just a rough translation, I have a German frontend) is being
displayed in the message log: "Query result with 100 rows has been
supressed. Query successfully completed after 50ms. No rows returned."
How do I get the values?
Another question: Does the ODBC oder OLEDB driver being provided for
Postgres already support this? Then we might switch from libpq over to
ODBC or OLEDB.
Thanx in advance,
Alexander