Update SQL for StoredProcedure

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 28
Joined: Wed 18 Jan 2012 20:15

Update SQL for StoredProcedure

Post by GNiessen » Tue 25 Feb 2014 22:51

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.

Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Update SQL for StoredProcedure

Post by AlexP » Thu 27 Feb 2014 11:45


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 .

Post Reply