1) What I've been forced to do by avoiding the need for extra database
objects is to save each sql cmd while iterating over a result from a query
and then executing each sql cmd sequentially.
2) yes
Hope this helps!
Randy
Software Engineer
Click2net Inc.
201-1599 Hurontario St.
Mississauga ON
Canada
On Fri, 25 May 2001, Patrick Welche wrote:
> Within a C++ program I essentially do
>
> PgDatabase db ("dbname=sameone")
> PgDatabase db2("dbname=sameone")
>
> db.Exec("BEGIN")
> db.Exec(select)
> loop over db.Tuples()
> db2.Exec(query involving results from db)
> do stuff with db2 result
>
> db.Exec("COMMIT")
>
> 1) Is the way to keep to results really to have 2 PgDatabase, or is there a
> simple way of saving the result set before having it replaced by the next
> query?
>
> 2) Does that BEGIN/COMMIT just apply to the queries in db, the db2 queries
> each automatically having their own transaction?
>
> I know I can experiment to find out, but maybe one of you already knows the
> answer...
>
> Cheers,
>
> Patrick
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>