[Openroad-users] Need help with strange problemusing QueryObject

[David Tondreau]

Or you could open a second connection to the database and perform your
other SQL requests on that connection.  Easy enough to do with the
DbSessionObject.Duplicate() method.

Regards, 

David 

David Tondreau
Architect, Ingres Corp.
http://community.ingres.com/



-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Bodo
Bergmann
Sent: Tuesday, June 26, 2007 2:55 AM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Need help with strange problemusing
QueryObject

Almost correct.

No SQL until you close it - as the 3GL select loop is still in progress.
So, Bills example using DBUpdate() in direct mode could cause problems.

I see it as a mode for read-only in special cases,
where you don't want to process all rows, e.g.
you could decide to process every 10th row only by using NextRow()
10times and then Load(),
or you just want to load rows 10 to 20. 

Bodo.

Bodo Bergmann
Senior Software Engineer
OpenROAD Worldwide Development
Ingres Corp.

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Simon Lovell
Sent: Tuesday, June 26, 2007 1:36 AM
To: openroad-users at peerlessit.com; Sean Thrower
Subject: Re: [Openroad-users] Need help with strange problemusing
QueryObject

Isn't QO_DIRECT analagous to an ESQL select loop.  No DB access allowed
until all the rows have been processed.




-----Original Message-----
From: "Sean Thrower" [Sean.Thrower at ingres.com]
Date: 26/06/2007 04:00 AM
To: "International OpenROAD Users" <openroad-users at peerlessit.com>
Subject: Re: [Openroad-users] Need help with strange problem using
	QueryObject

Note: Original message sent as attachment

________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

To unsubscribe click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe