Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File in use error when DROPping table via ADO/ASP
Message
 
To
01/09/2000 11:02:02
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00411126
Message ID:
00411949
Views:
11
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
Map
View

Click here to load this message in the networking platform