Re: [python-win32] adodbapi COM Refresh clears Parameters

2012-08-27 Thread Kenneth Chin
Hi Vernon, Yes, you're right on both counts, it's likely to be a bug in the provider, and given that VFP is no longer in development, I doubt that a patch for such bugs will be made available. While implementing executedirect() will definitely help fix my issue here, but will it also mean that ad

Re: [python-win32] adodbapi COM Refresh clears Parameters

2012-08-26 Thread Vernon Cole
Kenneth: Sounds like a bug in the provider, doesn't it. I would not expect to see a patch, so it's a good thing you found a work-around. You asked if there might be a way to always build the parameter list manually. Perhaps we can add one. I happily adopt features from other db api implement

[python-win32] adodbapi COM Refresh clears Parameters

2012-08-26 Thread Kenneth Chin
Hi, I have developed a Windows app using Python to access Visual FoxPro database using OLE DB Provider. Whenever I use parameterized query, it failed with the following error: (-2147352567, 'Exception occurred.', (0, u'ADODB.Parameters', u'Item cannot be found in the collection corresponding to t