Aurelius 4.18 Hangs in record Search.

Dear support,
this code work's fine in 4.17.2 but freeze in 4.18
class function TOperatoriHLP.getByUserName(_OBJ: TObjectManager;
_username: String): TOperatoriDTO;
var
_Operatori: TOperatoriDTO;
begin
try
_Operatori := _OBJ.Find.Where((Linq['UserName'].Upper = _username.ToUpper)).OrderBy('UserName').Refreshing.UniqueResult; /// <<< Hangs here!!!
result := _Operatori;
except
on e:Exception do
begin
var s:string:=e.Message;
end;
end;
end;
No exception is raised but the application does not respond.
I connect to a DB Postgresql version 12 using Firedac.
Can you help me?
Best Regards.

We need ways to reproduce the issue. Are you able to isolate the problem in a small project?

I found the problem ... both "association fetch mode" - "many-Valued association fetch mode" were set to "eager". Setting them to "Lazy" everything works.

1 Like

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.