HomeActive Query BuilderSql Server 2005 Custom Assembly Aggregate Functions

Sql Server 2005 Custom Assembly Aggregate Functions

Hi, I'm evaluating the activequerybuilder control (dotnet version 1.9) with sql server 2005.
I got a parser error when the sql text contains references to custom aggregates from a custom sql assembly ( things like commalistaggregate, mathor, mathand... )
If the custom sql aggragate contains DISTINCT ( eg: CommaListCOncatenate(DISTINCT fieldName ) the parser return a error: invalid token ap pos... the pos of the field name
If DISTINCT is not present the aggregate is not recognized as an aggregate function, but as a normal function.

There's a way to make the control recognize correctly custom aggregates ?

Stefano Marcias
June 24 2009, 04:29 AM
Dear Stefano,

We've added support for custom aggregates in MS SQL Server to Active Query Builder VCL and ActiveX Editions. The .NET Edition will have this functionality in a week.
Sergey Smagin | email
2 months, 1 week since original post
Dear Stefano,

Support of custom MS SQL aggregates is added to Active Query Builder .NET Edition.
Sergey Smagin | email
2 months, 3 weeks since original post
This topic is closed