Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedures
Message
From
09/07/1999 19:39:06
 
 
To
09/07/1999 15:40:07
Doug Lawrence
Center For the Rocky Mountain West
Missoula, Montana, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00239620
Message ID:
00239711
Views:
8
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform