Ken,

Please forgive my ignorance here, but just HOW does this make VFP a "middle tier" app (in the 'demos' you report on)????

I don't see MIDDLE here at all!

Jim N

>>I guess we are on the skepticism bandwagon over the state of VFP and what M$ wants to do with it.
>
>I just came back from a seminar, and the word is that M$ is positioning VFP to be the middle tier in a n-tier architecture. They have finally realized that when it comes to data maniuplation no other VS app comes close. It was quite amazing to see a VFP COM server process data from:
>
>1. Inside a VB application
>2. See three pooled instances of it running simultaneously inside IIS processing data from three open browser windows.
>
>
>>1) We became the victims of one of the 17 first documented bugs. When you execute multiple SQL queries in a group of code, each subsequent query "suffers a degradation in speed to complete the query". The degradation was double the speed in our experience. Trust us that we tested the same code and data on the same machine, and tried to give both 5.0 and 6.0 the benefit of the doubt as to comparable operating environments. M$ solution(interim) was to change all "where" statements to "having" and that would solve the problem. Well....... it now takes between 3 and 4 times longer to execute the query in 5.0 vs. 6.0
>
>I believe the documentation states the problem exists when you *combine* "OR" with your "WHERE". I have a table with 185,000 records in it and saw no change in performance if no OR statment was used.
>
>>Anybody in the know out there? Let me down hard now, rather than dragging me out and trying to let me down easy.
>
>I left the seminar totally up...these folks are *very* close to M$, and they are elated about the positioning going on with VFP inside VS.