Great idea but I bet it's a LOT of work
I think we'd be better having a true server version of VFP which is marketed as a low end (cheap) version of SQL server.
IMO One of the biggest problems with SQL server is the lack of record related commands - it's a real pain just to do something like a Scan loop
Will
>Ricardo,
>
>Now that VFP is out of VS.NET, what if MS chose to integrate VFP very tightly with SQL Server?
>
>We know that the Fox syntax is wonderful for database applications. Let's say you could SET DATAENGINE TO SQLSERVER and have all fox command syntax available against SQLServer tables?
>
>Think about it: Inline SQL Select, BROWSE, REPLACE, SCAN, LOCATE, SEEK, APPEND FROM. Heck, even SCATTER/GATHER for easier migration of old apps :)
>
>MS would win because it would be easier to write apps for SQL. We would win because Fox would have a solid mission within MS products. Only Oracle would have to worry.
>
>What do you users of the UT think?
>
>Alex
Will Jones