Aggregate user function

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
nszmnsky
Posts: 15
Joined: Wed 21 May 2014 17:07

Aggregate user function

Post by nszmnsky » Wed 20 Aug 2014 16:02

Can TLiteUserFunction be used to build an aggregate function? Specifically, I'd like to implement standard deviation and median/mode calculations. But the demo only shows examples (ABS, PERCENT) for function acting on a record.
Thanks
Neil
Top
PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

Re: Aggregate user function

Post by PavloP » Thu 21 Aug 2014 08:27

TLiteUserFunction does not allow creating aggregate functions.
Top
nszmnsky
Posts: 15
Joined: Wed 21 May 2014 17:07

Re: Aggregate user function

Post by nszmnsky » Fri 22 Aug 2014 03:49

Thanks for the update, I had already started writing code to walk thru the query records to calculate the StdDev.
Top
PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

Re: Aggregate user function

Post by PavloP » Tue 26 Aug 2014 14:07

If any questions concerning our products come up, please contact us.
Top
Post Reply

Return to “SQLite Data Access Components”