[Openroad-users] Need help with strange problemusing QueryObject

[Bodo Bergmann]

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