It's called SPT for a reason. Whatever you specify as 2nd parameter in SQLEXEC() is passed to a backend for excution w/o changes. IOW, you call SP the same way as you would in the backend.
>Thanks for the idea of creating a stored procedure and both the trigger and SPT calling it. Can you help me on how to call a SP from VFP. I have done SPT for SELECTs but is calling a SP as simple as calling a function in VFP?
--sb--