Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric Moss
  Where is Eric Moss?
 O'fallon
 Missouri - United States
 Eric Moss
 To: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 Tags
Subject: RE: VFP Replace and SQL server/CursorAdapter
Thread ID: 268804 Message ID: 268823 # Views: 40 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, July 14, 2010 8:38:48 PM         
   


> > Hello, all!
> >
> > I'm having an issue with some code I'm working on. I have a cursor adapter of a table, into which I'm using an INSERT...INTO from a memvar. At this point, it's working fine, but anytime i try to use a REPLACE into the CA, i run into problems.
> >
> > I'm receiving the following error:
> >
> > Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value. VFP replace
> >
> > Which doesn't tell me a whole lot. Looking online, people say that this is caused by nulls being put into fields that don't allow nulls, or fields being filled with data that's too long.
> >
> > However, the table is allowed to have null data on each field, and i've stepped through the program, and the values being replaced are within the parameters of the fields. At this point, I'm unsure what the problem is, has anyone run into this before? It doesn't seem to matter what i replace, or which field in specific, i've tried several.
> >
> > Thanks in advance!
> >
> > Cheers!
> > -EM
>
> It might be possible u r try to update field with value more than field width!. try to update value with trim
>
>
> Anil
>
> My Blog

I've considered and tried this, and it didnt work. However, i did compare the len() of the data compared to the field length as defined in the database and it was fine.

I'm also getting it with numerical data, and both the data being inserted and the field are N(9,4)

Cheers!
-EM

ENTIRE THREAD

VFP Replace and SQL server/CursorAdapter Posted by Eric Moss @ 7/14/2010 6:19:21 PM
RE: VFP Replace and SQL server/CursorAdapter Posted by Anil Sharma @ 7/14/2010 8:28:25 PM
RE: VFP Replace and SQL server/CursorAdapter Posted by Eric Moss @ 7/14/2010 8:38:48 PM
RE: VFP Replace and SQL server/CursorAdapter Posted by Stefan Wuebbe @ 7/17/2010 10:07:01 AM