1. You create a class in VFP that will be compiled as a DLL.
define class MyClass as custom olepublic
FUNCTION SaySomething()
RETURN 'Hello from inside a VFP function'
enddefine
2. Compile your class as a DLL.
3. Call your class from inside an ASP page.
< % set oVfpClass = Server.CreateObject( [MyDLL.MyClass] ) % >
< % =oVfpClass.SaySomethig() % >
< % set oVfpClass = nothing % >
You VFP class can receive parameters and read/update data based on those parameters.
>How does this work?
>
>
>>1. Write code to Insert, Update and Delete in my ASP code?
>Can be done but it gets messy pretty soon.
>
>>2. Create VFP Stored Procedures in the Database?
>Can be done.
>
>I would add a third option:
>3. Create VFP COM DLL that you can from your ASP to do the operations on the VFP data.
Hector Correa