Jump to content
Sign in to follow this  
Kyle Miller

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

Recommended Posts

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 --


FDDataSet.FieldX.AsInteger := 12



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



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 by Kyle Miller

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this