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

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