Aggregate field problem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
szuwar999
Posts: 1
Joined: Thu 13 Mar 2008 21:22

Aggregate field problem

Post by szuwar999 » Thu 13 Mar 2008 22:01

Hello,
I'm creating an application where I need to use aggregated field functionality.
I've defined two TMSTable components with master - detail relation, then I've added field with type "aggregate" to "detail" table field list. Expression property contains SUM() function with proper field name within parenthesis. "Active" property of aggregate field is set to true.
In my project there's DBText object to which I've bound aggregate field name.
Whatever I do this DBText is always empty.

What am I doing wrong?
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 14 Mar 2008 11:12

I am not sure that I have understood you correctly. Could you send me at evgeniyd*crlab*com a small sample that demonstrates this situation? Please do not forget to include a script to create and fill tables at the server.
Top
Post Reply

Return to “SQL Server Data Access Components”