Best Practice is to use Stored Procedures, which are not supported by RVs.

In addition to the VFP docs, here are some places to get started. Some of these articles are a bit dated and talk about some technologies that are no longer used (RDS for example), but still contain some good information.

http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_bko01.asp
http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_fpsqlcs.asp
http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_bko02.asp
http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_usevfp.asp
http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_embeddingmsde.asp

There are some sample chapters you can download from http://www.hentzenwerke.com/catalog/csvfp.htm

>I'm using VFP 9.0 and I want to create a app using SQL all my apps have been using VFP backend. Do I use the remote views or can I call the store procedure from SQL. Can you point me the right directions for this enviorment.
>
>Thanks
>Randy