>I am developing an ASP web application using a VFP Database. I was wondering what the perfered method is:
>
>1. Write code to Insert, Update and Delete in my ASP code?
>
>2. Create VFP Stored Procedures in the Database?
>
>If stored Procedures, how about an example of how this works.
Really you need to determine what the future holds for your application... if you can absolutely guarantee that you will never switch to another database, you can create an intelligent database.
However, since you can't do this <g>, I would suggest a 3-tier design with the business logic in a middle tier that can update your database.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown