SQL statement doesn't return rows?

[AudioPat]

Hello,

When we save a updated entity, this result into a SQL statement doesn't return rows error?
The entity has assocations.

Why do you declare a temp table for updating a record?

Code: Select all

DECLARE @tempVar TABLE(ContainerID INT); update dbo.Moves set VerhuurOrderID = @P1  OUTPUT INSERTED.ContainerID INTO @tempVar  where ID = @P2',N'@P1 int,@P2 int',3,33

When setting 'VerhuurOrderID = Value' then the SQL statement doesn't return rows. When you do not set this ID, the update is succesfully updated.

Code: Select all

  aMove.VerhuurOrderID := aVerhuurOrder.ID;
  DataContext.Save(aMove); // SQL statement doens't return rows.

Code: Select all

  //aMove.VerhuurOrderID := aVerhuurOrder.ID;
  DataContext.Save(aMove); // Update succes

[AlexP]

Hello,

We can't reproduce the problem. Please send your model and a sample to support*devart*com .