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.