Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disable MetaData re-sending in ADO
Message
From
12/07/2001 04:54:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Disable MetaData re-sending in ADO
Miscellaneous
Thread ID:
00529586
Message ID:
00529586
Views:
44
When I'm using ADO I noticed in the SQL Profiler stuff like:

SET FMTONLY ON
SELECT MAINKEY FROM STYLES

Fair enough it sends the metadata. But it does this every time
I move next,prevous (on a Server side cursor).

As far as I recall there is no way to disable the sending of
metadata each time. Or is there?

Anyone know if this is planned or if you can add a request for future
ADO versions to do this?

As far as I'm concerned this only needs to happen once when you open the
cursor. Ok maybe a column type changes but we shouldn't do this while the app is runnnig any ways.

I suppose the overhead is minimal or is it?
Next
Reply
Map
View

Click here to load this message in the networking platform