>Hello;
>
>Is there a way I can use VFP6 as a front end and SQL server tables as a backend. The thing is I have created an application that collects phone calls from cisco routers i.e. call detail records, then I rate the calls, create reports and invoices for my customers based on their usage. FoxPro tables as you know has a limitation in number of records and table size. Very soon I need to migrate my call detail records to SQL server. Is their a good documentation or a book that teaches me how to do it and how to keep Foxpro as frontend and SQL as my backend. I'm totaly in the dark about this issue.


Yes, you can definitely use VFP as a front end to SQL Server data. You can do this using either VFP remote views or something called SQL Pass-Through, which is simply passing SQL commands from VFP to SQL Server to be executed there. Neither approach is complex. Both are explained very well in the book mentioned by Sergey, written by Urwiler, DeWitt, Levy, and Koorhan.

In addition, be aware that the upcoming next release of Visual FoxPro, VFP 8.0, has beefed-up support for SQL Server.

Good luck!

Mike