[Openroad-users] Need help with strange problem using QueryObject

[Sean Thrower]

Bill,

 

QO_DIRECT is not intended to be used (don't ask) - use QO_CACHE instead.

Believe the message, set the queryname! (there's QO.Name, and there's
QO.QueryName).  If it makes the queryobject feel better, it's worth it.

 

Let me know if it is still being wilful.

Regards,

Sean.

 

________________________________

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Collins,
William - ES/EW
Sent: 25 June 2007 18:20
To: International OpenROAD Users
Subject: [Openroad-users] Need help with strange problem using
QueryObject

 

 

I create a QueryObject and populate the Tables and Columns arrays. 

Then I open the query: 

qo_Object.Open( QueryMode = QO_DIRECT, 
                  Scope        = CurFrame.Scope, 
                  CheckCols = TRUE); 

This works fine, with no error. Then I Fetch each row: 

qo_Object.NextRow(); 
qo_Object.Load(); 

All of this works fine, I've checked it in the debugger. 
Then I calculate a new value for one of the columns and attempt to
update the table: 

qo_Object.DBUpdate(zerorowsiserror      = FALSE, 
                        isrepeated             = TRUE, 
                        maxrows         = 1); 

This gives these errors in the Trace Window: 

E_WT0029 Error at line nnn of frame_name. 

E_OM00B3 Error in DBUpdate method on queryobject. 

E_OM00AE Query name has not been provided. 

I have not found documentation anywhere that talks about providing a
Query name. Can anyone point me in the right direction?

TIA, 
Bill Collins, 
Software Engineering Consultant, 
President, OpenROAD Users International 

*****************************************************************
This e-mail and any files transmitted with it may be proprietary 
and are intended solely for the use of the individual or entity to 
whom they are addressed. If you have received this e-mail in 
error please notify the sender. Please note that any views or
opinions presented in this e-mail are solely those of the author 
and do not necessarily represent those of ITT Corporation. The 
recipient should check this e-mail and any attachments for the 
presence of viruses. ITT accepts no liability for any damage 
caused by any virus transmitted by this e-mail.
*******************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20070625/acd52e12/attachment.html