General information
Category:
COM/DCOM and OLE Automation
>>Hi Cetin, I asked this question to the whole UT, but wonder if you know the answer.
>>
>>Alex
>>
>>I have a procedure that uses some code from Cetin to fill Excel workbook from VFP cursors.
>>
>>The code creates an ADO recordset from the VFP cursor, saves the recordset to an intermediate rst file, and later opens the rst file from excel.
>>
>>This code works well in one procedure but not another. In both cases the code is called twice to fill two Excel sheets. In the routine that fails it does during the second call when the recordset is being saved to the rst file. The error is: OLE IDispatch exception code 0 from Microsoft OLEDB persistence Provider: Multiple-step operation generated errors. Check each status value...
>>
>>In each case the code checks to make sure the rst file has been erased before attempting the save.
>>
>>Any suggestions?
>>
>>TIA,
>>
>>Alex
>
>Alex,
>Just yesterday I needed it and the source was a cursor. Instead of saving to RS and reopening it, I now do selecting into a temp table in a temp dbc. Then create an RS from that and use CopyFromRecordset method. I will keep this message and send the code tomorrow when I get to my work computer.
>Cetin
Thank you. Look forward to it.
Alex
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only