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
 Tags
Subject: VFP Replace and SQL server/CursorAdapter
Thread ID: 268804 Message ID: 268804 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, July 14, 2010 6:19:21 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

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