>I use ASP's to acess my VFP 5.0 database. I want to move all my queries into VFP stored procedures. HOW DO I DO IT! I have discovered how to add the procedure but I think my syntax is incorrect. Anyone?
>
>Doug
Just add the procedures that create your cursors to the DBC. They would all have to use "INTO CURSOR Whatever". Then creating the cursors is as easy as calling hte procedure.
I have to question your reasoning for doing this though- generally if there are result sets that you use over and over, you would want to create a view out of the SQL that creates them. Then you server only has to open the dbc and issue a USE MyView.
Erik Moore
Clientelligence