"OLE IDispatch exception code 0 from Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value..."
We use the following piece of code:oConnection = Createobject("ADODB.Connection") oConnection.Open("SQLTEST","UserName","PassWord") oRecordSet = CREATEOBJECT("ADODB.RecordSet") WITH oRecordset .Cursorlocation= 3 && Use Client .CursorType = 3 && Open Static .LockType = 3 && Lock Optimistic .Open("mytable", oConnection) && SQL table (target) .MarshalOptions = 0 && Marshal All SELECT MyTable && VFP table (source) lnFldCnt = FCOUNT() SCAN .AddNew() FOR lnF = 1 TO lnFldCnt .Fields(FIELD(lnF)).Value = EVAL(FIELD(lnF)) && it fails here when lnF > 1 ?.Fields(FIELD(lnF)).Value ENDFOR .Update() ENDSCAN ENDWITHAny help is greatly appreciated.