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--