Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedures in Fox Pro
Message
 
 
To
02/10/2002 19:26:29
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00707160
Message ID:
00709819
Views:
14
VFP stored procedures can be only executed through VFP OLE DB provider. Take a look at HOWTO: Execute a Stored Procedure in a VFP Database with the VFP OLE DB Provider mskb #Q299820. I don't know if it works from ASP. Here's another article that could be of interest to you HOWTO: Create an Auto-ID Field in a FoxPro Table by Using ADO and ASP mskb #Q316910.

>Hello, I hope this is not a discussion that has been beaten to death but, is there a way to call a stored procedure from an asp script in a VFP database. I am trying to get over the problem of getting reliable unique indexes for my tables after deletes have been made. I want to keep the deleted records and not pack the tables but I get the uniqueness of index violation.
>I also do not want to use an asp hack to get a new index becouse without a stored procedure I am afraid that I will possible enable users to get non-unique ids.
>Any help appreciated,
>Casimiro
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform