I'll try to create an SQL cursor as in test045.cxx.
On 4/8/07, John Mudd <[EMAIL PROTECTED]> wrote:
> Oh, this works. But this reads all results at once. I need to be
> able to fetch one result at a time.
>
> prepare::declaration D2 =
> C.prepare("q1", "SELECT * FROM x WHERE num > $1");
> D2("varchar", prepare::treat_string);
>
> prepare::invocation Inv3 = T->prepared("q1");
> Inv3("222");
> result R = Inv3.exec();
>
>
>
> On 4/8/07, John Mudd <[EMAIL PROTECTED]> wrote:
> > Any examples using a prepared statement with a cursor?
> >
> > e.g. "SELECT * FROM x WHERE num > $1"
> >
> > John
> >
>
_______________________________________________
Libpqxx-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/libpqxx-general