>What do you mean by post? If I run the SP out of query analyzer, the value 1 is returned afer the undelete update. Which is what I want, but in foxpro the value 0 keeps returning, it is as if the cursor does not get filled correctly.
OK. then run SQL Profiler, filter to watch only your application events and see what commands you send to SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.