Craig - those links would haved saved my sanity in a former life. I know longer have to deal with a VFP front end now though, but I will pass them on to my old employer to hopefully save the minds of those who will replace me....

Thanks,

-Justin

>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