Update SQL for StoredProcedure
Update SQL for StoredProcedure
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
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 .
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 .