FireDAC: Sql Server - How do I see uncommitted app updated values in a stored proc?

[Kyle Miller 1]

Using Delphi 10.4.1 w/connection transaction level set to dirty read. When I execute a stored procedure, which also executes set trans iso level to uncommitted, the stored procedure doesn't see an update performed in the app.

 

Here is the outline of events --

FDCon.StartTrans

FDDataSet.FieldX.AsInteger := 12

FDDataSet.Post

FDStoredProc.Exec

... Here the stored proc selects FieldX and see it as null, not 12. Why?

FDCon.Commit

 

I want the stored procedure to see the uncommitted values posted by the app.

 

EDIT: Cancel request. Turns out to be a stored procedure bug.

Edited September 22, 2020 by Kyle Miller