Hi,

I have not heard of this bug. I do notice that the second time I run my application that is front end for MS SQL server, it runs much faster.

There might be some caching at the VFP end also.

HTH,

Paul


>I set a the Precompiled Option of one remote view to .T.
>and I did NOT see any difference.
>
>I am tracing the SQL statements sended to the server with
>the "SQL Trace" tool.
>
>I heard that this option will create a store procedure in
>the SQL Server and then, subsecuent calls to that view
>(while the connection still alive) will use the store
>procedure to make the query faster. Also, I heard that
>there is bug in VFP that cause VFP to ask the server to
>create the store procedure but it never execut that store
>procedure!
>
>I am trying to reproduce this but I did not see when VFP
>ask the Server to create the store procedure (of course
>I neither see when it ask for its execution).
>
>Does somebody have work with this?
>
>Thank you,
>Hector Correa