we are calling a DB2/stored procedure from Visual Foxpro and the SP is returning a record set. the routine that is converting the record set to VFP table encountered a low date value in one the DB2 date fields the DB2 value is 0001-01-01 this line of code in section below lvValue=oField.value is throwing this error "OLE IDispatch exception code 0 from Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value." when field is date and the value in DB2 is 0001-01-01 in the VFP debugger oField.value show "expression could not be evaluated" we tried hiding the error but it does work because this section of code is being call from a VFP Web service that is returning a Null value upon encountering the Error. __________________________________________ FOR lnCount2 = 1 TO lnFieldCount oField=rs.fields(lnCount2-IIF(llRecNoColumn,0,1)) lcField=oField.name lvValue=oField.value
Any idea how to resolve it. Jean --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
