aggregate field troubles

[Zoltan]

Hello !
I'am ussing trial version 3.50.0.20

Have a folow problem:
I create TMyQuery and add aggregate field, set property active to true,
expression is sum(qty) (also try with 1*sum(qty)), then with DBText want to retrive value from this field, but result never appear !!!

Please help !

Thanks
Zoltan

[Ikar]

Please specify in what the problem is. Does your application hang on try to execute a query?

[Zoltan]

Hi !
Thanks for answer !

About aggregate fields trouble (Delphi 7.0):
1. create my TMyQuery
2. create aggregate field
3. write to expression sum(qty) (qty is filed with quanity)
4. set property active to true
5. create DBText and assing it to aggregate field to read value
6. run application
7. when open query DBText not show sum(qty) value. They are also empty. Application run, but aggregate field don't calculate.

May I do some wrong?

Hope above help you to find a problem !

Thanks in advance
b.r.
Zoltan

[Ikar]

Can you get a value of the field through MyQuery.Fields[].AsString?
Can this value be displied in DBGrid?
Please specify script to create tables and text of the query.