>To anyone else reading this thread, a lot of this debate can be found at:
>
>http://fox.wikis.com/wc.dll?Wiki~MoreOnRemoteViews~VFP
>

I hope you don't rely too much on this link. It is riddled with inaccuracies...



>
I don't have the expertise yet with T-SQL to do the data-manipulation that I can fairly easily do with VFP. While I have read that T-SQL can do anything, I am not going to invest the next n months becoming a T-SQL guru. I am going to learn it gradually, and move what I can, when I can, to sprocs. And the application I am working on now manipulates a lot of data.
>

One does not need to rely soley on T-SQL. While you can, it is often not the best thing to do. VFP has a great DML - indepdendent of working with VFP cursors. VFP is very effective at crunching through ADO recordsets - as well as VFP cursors.


>As an example, I am working on a project that uses a company's historical financial data (total assets, total net income, etc.) to determine it's relative worth in the stock market. If the latest record for a company is a quarterly record rather than a yearly record, I have to project the last four quarters to create a projected year.
>
>Then I have to look at each year, compare values to the previous year, and so on, to help determine whether a company is unvervalued or overvalued. I can use VFP cursors to project 4 quarters to a year, and VFP arrays to compare a year to the previous one.
>
>Could someone do all this with T-SQL? Probably. Is it easy? I don't think so.
>

You can do it in T-SQL. As far as comparing with VFP, VFP is probably easier. However, it is not a huge task with T-SQL either. It is a matter of knowing T-SQL. If you don't know it that well, it will all seem Greek to you..

>
Scalabilty is a relative term.
<

A true statement of fact!!


>
My VFP middle tier is accessed by one client, a VFP program that calculates each stock's relative worth throughout the day. The results of these calculations are stored in SQL Server. A Cold Fusion gets these results via stored procs. So for my situation, remote views work well.
<

Scaleability is also a relevant discussion in terms of maintenance. When your schema changes, RV's often break. I can see why RV's can work for you - since you are using Cold Fusion - a great product IMO. For ODBC-Based data connectivity - it is an ASP-Killer.

< JVP >