Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Stored Procedures for Client/Server web app
Message
 
To
10/08/2001 11:18:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00542283
Message ID:
00542439
Views:
15
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
Previous
Reply
Map
View

Click here to load this message in the networking platform