Re: C++ usage question

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)
> 
>