Sorting by calculated field does not work

[alexkam75]

I create a calculated 'qty' field as TFloatField in TZQuery.
OnCalcFields
Queryqty.Value := 4;
When sorting
FieldName := FixFieldName('qty') + ' Asc'
TZAbstractRODataset(ADataSet).SortedFields:=FieldName;
Error appears

[marsupilami]

Hello,

which version of Zeos do you use? I seem to remember thios was a problem in Zeos 7.2. But I thought it was fixed for Zeos 8.

Which error message do you get?
Which version of Delphi or Lazarus / Freepascal do you use?
Can you provide a small sample application?

With best regards,

Jan

[alexkam75]

ERROR: ACCESS VIOLATION
lazarus-3.2-fpc-3.2.2-win64
zeos 8.0 last
http://svn.code.sf.net/p/zeoslib/code-0 ... .0-patches

Sample project:
https://disk.yandex.ru/d/o8XHP42Xq0-Z8Q

[alexkam75]

Sorting by calculated field does not work. Example attached.

[alexkam75]

The error occurs in the file\src\dbc\ZDbcCache.pas

[alexkam75]

error1.png

[alexkam75]

Error executing CurrentRows.Sort(HighLevelSort)
procedure TZAbstractRODataset.InternalSort;
in src\component\ZAbstractRODataset.pas

[marsupilami]

Hello,

there seems to be an hard to fix issue with the way we handle calculated fields. We are currently investigating this. I willanswe when we have a solution ready.

With best regards,

Jan

[marsupilami]

Hello,

we think we solved your problem. Could you please check if the latest 8.0-patches branch works for you?

Best regards,

Jan

[alexkam75]

Thank you. Sorting works.