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

Reply via email to