I previously posted the following POST on how to avoid dirty reads.
Dirty Reads when using SQL Server
I received your reply.
However, I do not understand where the setting location described below is.
"You can control it by using a specific SQL action by configuring it in the "Advanced SQL Options" section. However, in Aggregates and regular SQL actions, you don't have direct control over it. "
If you know where to set it, please let me know.
thank you.
I would suggest contacting OutSystems Support. I don't think the community can help you with this, if you use a managed enviroment.
Hello @Akari Ukai ,
You need to post in English, otherwise, the community won't be able to help you. :)
It was helpful. thank you！
Hi Akari,
Please do not create a new post and expect people that replied to your previous post to read it, that's not how a forum works. In this specific case, I think the person replying used ChatGPT, and I deleted the answer since it was basically nonsense - there is no "Advanced SQL Options" section.
I'm sorry that I used the Forum in the wrong way.
You said there is no "Advanced SQL Options" setting, do you know if there are other ways to deal with dirty reads on the SQL server?
I am facing the above problem right now.
I would appreciate it if you could help me with a solution.
Best regards.
I understand.
Thank you very much.