Page 1 of 1

Update SQL for StoredProcedure

Posted: Tue 25 Feb 2014 22:51
by GNiessen
I have an Stored Procedure that returns a set of records. It uses a temporary table to build the record set. But I have a table that it uses that I want to update when the records are edited. But it seems to know that it is based on #TestResults and not the dbo.TestResultDetail table and wont let me edit it. Even though I have a valid UpdateSQL in place.

Re: Update SQL for StoredProcedure

Posted: Thu 27 Feb 2014 11:45
by AlexP
Hello,

We cannot reproduce the problem. Please send the scripts for creating all the used DB objects and a sample reproducing the problem to alexp*devart*com .