i am a software programmer in dubai.I have developed software using vfp8.0 as frontend and sql server 2000 as backend.I have created stored procedures for the insert,update and delete for each table.Is it possible to create just three procedure for Insert,Update & delete. Each can be given a cursor and the table name as a parameter whereby it can insert ,update and delete in any table whatsoever.

We have taken a different approach. Our data classes handle this in the middle tier.

If you are interested, you can download the data classes, code samples and a white paper expalining how they work from our web site. Just keep in mind that since they are in the public domain, they are not a product and we do not provide support for them.