John;

I downloaded the information on the VFP and SQL Server versions. It looks very interesting and I am going to discuss this with our staff.

Tom

>Hi Thomas..
>
>It is an excellent product. If you note, while my intentions and integrity have been questioned, the merits of the product have not.
>
>If you want the power of SPT with the ease that RV's are supposed to give you, check out Dataclas/VFP, the only C/S data framework for VFP available today.
>
>And just to reiterate, I have a small interest in Dataclas/COM, not Dataclas/VFP. For VFP apps, dataclas/VFP is the way to go. So you see, in reality, these reccomendations actually cost me $. No big deal of course because suggesting the right product to people is the ethical and correct thing to do.
>
>
>
>
>>Steve;
>>
>>Must be a good product as John mentioned it in messages #572419
>>and #572825. :)
>>
>>Tom
>>
>>
>>>John, please, if you have a pecuniary interest in recommendations you make, you should say so.
>>>
>>>Here you are, with an "MVP" in your sig, pushing your own product like that. I think that's ethically borderline, don't you?
>>>
>>>**--** Steve
>>>
>>>
>>>>Check the indexes on your backend. If you are using SQL Server, do you have a clustered index? Does your search criteria match an index? And finally, make sure the server hardware is adaquate.
>>>>
>>>>Another thing to check: are you minimizing the number of records you need to fetch from the server?
>>>>
>>>>Lastly, Go to www.redmatrix.com and check out dataclas. If you find yourself in a situation where you can ditch the RV's, try Dataclas.
>>>>
>>>>Good luck!
>>>>
>>>>
>>>>
>>>>>Hi all,
>>>>>How to speed up a SQL remote view when calling out from VFP ?
>>>>>I have tried to using the fetch mode. It can return the control
>>>>>so fast and the program can be opened quickly. But when I issue
>>>>>tableupdate(.t.) command, it return an error, it is the connection
>>>>>is busy. I know all records of the table is being fetch at the
>>>>>background. Thus I can only update the table after the fetch is
>>>>>completed. And if I interrupt the fetch process, the table can't
>>>>>be updated. When the table is so large, the fetch time is so long.