hi
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.
i mean a procedure called insert_table("xTableName","xCursor") where xCursor contains fields and values.
this will make my task real easy and it will save a lot of time
Thanks
Riyaz Patanwla
Dubai
U.A.E.
Riyaz Patanwala
I. T. Programmer
Al Jaber Energy Services L.L.C.
P.O.Box 47467
Abu Dhabi, U.A.E.
Tel - +971 2-502-1644
Fax - +971 2-554-6106
Cell - +971 50 358-0229
Email -
riyaz.patanwala@ajes.aeWebsite -
www.ajes.ae