Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error while creating ADO recordset with VFPOLEDB
Message
 
 
À
04/06/2009 16:20:49
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01403799
Message ID:
01403801
Vues:
56
>Hi,
>
>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

Did you try to close Excel and re-open? We were having similar errors, BTW, when I was trying to run it with the debugger open.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform