So I wonder if there is a bug with the VFP odbc driver that keeps me from doing the Drop on the first try...
>>I was afraid you'd say that.
>>
>>I tried that on my first attempt, but my "IN string" ends up being too long. The IN field is 17 chars long and there can be any number of them. I came up with one "normal" instance where there are 65 items in the IN list.
>>
>>My query crashed with an error that the query is too complicated(or something similar).
>>
>>Any ideas for properly deleting the temp table?
>>
>>I REALLY appreciate your suggestions and time.
>>
>>
>
>You could put this all in a VFP COM component and manipulate the data with native VFP commands. COM components are faster than interpreted VBScript. The COM component could return an ADO recordset if needed.
>
>Make sure you mark your COM component as "multithreaded DLL".
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement