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
 To: Graham Brown
  Where is Graham Brown?
 East Midlands
 United Kingdom
 Graham Brown
 Tags
Subject: RE: Error Message
Thread ID: 104624 Message ID: 104677 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Errors & Debugging
Date: Saturday, August 19, 2006 3:54:51 AM         
   


The "A" & "B" table as I mentioned is different structure. They both oracle table. when pulled it down using my Class curAdapter('myalias','select * from Oracletable',loConn) from Oracle to VFP the "B" gets error and "A" table works fine. Thanks.

> 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




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