Thanks Della. Great news. I'll take a look at it.
>>In Poland for example one can buy library MEDIATOR. With MEDIATOR, programs written in Clipper can write to SQL Server or Oracle DATABASE trough Clipper RDD architecure, and there are a few changes in Code requiered. MEDIATOR advertisements are sponsored by Microsoft. I don't know how efficent are such programs in practice.
>
>There's a product for VFP called DataClas VFP, produced by Red Matrix Technologies. It does a great job of managing the communications between VFP and SQL Server. See
www.redmatrix.com for more info on the product.
>
>This product is fast, so you don't have to worry about degrading performance. It uses a data controller object that fetches the data (via SQL Server stored procs) and stores the fields as properties of the object; if child records are returned, they're returned to a cursor that the data controller tracks. It's an elegant solution. Yes, you might have to rearchitect your app a little to match SQL Server's set orientation, but it sure makes life easier. You can still leverage your VFP knowledge while using a SQL Server backend.
>
>HTH,
> - della