>>>>> Like you, I really want it now, but I'll wait if it means getting a really solid product.
>>>>
>>>>That's precisely why I asked. I'm looking at migrating my data warehouse backend environment from FPW2.6 to SQL Server, and from all I've heard about the improvements in 7.0, I think I'd rather wait on it too if I don't risk hitting the 2gb limit in Fox before they get it out.
>>>
>>>Which would probably mean that you would migrate to VB also. If you are not going to stay with the DB backend why stay with VFP?
>>
>>There's usually still a fair amount of data manipulation even in a front-end application. In a 3-tier app much of that may end up in the middle tier, but for 2-tier I think VFP is still a good idea for a front-end.
>
>Are you suggesting a mixed database environment within an app? DB tables and VFP code for, say, username tables, security, etc., and SQL backends for data manipulation?
Nope. All the data's in SQL Server. However, you often want to manipulate the result sets you get back from SQL Server or manipulate data the user enters before it's sent to the back end.