Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Gary Abellar
  Where is Gary Abellar?
 Bacolod City
 Philippines
 Gary Abellar
 Tags
Subject: Error Message
Thread ID: 104624 Message ID: 104624 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Errors & Debugging
Date: Friday, August 18, 2006 3:11:23 PM         
   


What is the cause of this ERROR?

I've created a class for cursoradapter using recordset as a Data source and Data source Type as ADO.

when I've load "A" table from oracle works fine, but "B" table it show

error message:
**********************************************************************
"OLE IDispatch Exception Code 0 from Microsoft Cursor Engine:Multiple-step operation generated errors. Check each status value"
***********************************************************************

What is the cause of this error? Why "B" table created an error mensioned above while "A" table works fine? They are both oracle table.

Here's my code:
================================================================

with loCursor
.Alias = (cAlias) && Parameterize
.Datasourcetype = 'ADO'
.Datasource = oRecordset
.Selectcmd = (cSelect) &&Parameterize
loCommand.ActiveConnection = loConn
if .cursorfill(.F.,.F.,0,loCommand)
&& successfull
else
AERROR(laErrors)
messagebox(laErrors [2])
endif
loCommand.ActiveConnection = loConn
endwith
endif
================================================================

Anybody helps me in solving this problem.

Thank's

Gary

ENTIRE THREAD

Error Message Posted by Gary Abellar @ 8/18/2006 3:11:23 PM
RE: Error Message Posted by Graham Brown @ 8/18/2006 7:27:30 PM
RE: Error Message Posted by Gary Abellar @ 8/19/2006 3:54:51 AM