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".
Previous
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