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


Hi

Isn't this normally down to the cursor adapter having a different structure to the underlying table?

For instance the cursor adapter says that it has a char(5) and the underlying table is a char(10) or the ca has a field of one type and the table has a different type?

Please let me know if this makes any sense!

Rgds
Graham

> 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