>I Tried:
>nconhandle = sqlExec(nhandle, 'EXECUTE myprocedure(dweek_act)', mycursor')
>What I got was nconhandle = -1. But like I told John, ?myprocedure(dweek_act) works in the command window with the database open.
Sorry, I should have read your post more closely :-). I thought you were using SQL Server as the backend. I don't think you will get any performance gain from sprocs in VFP.
Chris McCandless
Red Sky Software