how to use aggregates fields with unidac and firebird? any example?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gss200610
Posts: 35
Joined: Mon 23 May 2016 22:29

how to use aggregates fields with unidac and firebird? any example?

Post by gss200610 » Sun 25 Feb 2018 17:38

how to use aggregates fields with unidac and firebird?
any example?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: how to use aggregates fields with unidac and firebird? any example?

Post by ViktorV » Mon 26 Feb 2018 08:10

Please specify what is the essence of your question and what do you mean by the phrase "aggregates fields".

gss200610
Posts: 35
Joined: Mon 23 May 2016 22:29

Re: how to use aggregates fields with unidac and firebird? any example?

Post by gss200610 » Mon 26 Feb 2018 17:45

I need a table field to be automatically calculated every time I log in, that is, add the items to each entry in cached update mode without having to do a while loop

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: how to use aggregates fields with unidac and firebird? any example?

Post by ViktorV » Tue 27 Feb 2018 11:29

If you need to use calculated fields in the dataset, then you can easily use them both in the CachedUpdates mode and without it. If you need to use the calculated fields at the database level - this question relates mostly to the architecture of your application and the functionality of the DBMS, rather than the UniDAC functionality. Therefore, to get an answer to your question, you can refer to the DBMS documentation or ask a question on the relevant forums. Regarding the functionality of our components, more specifically the use of the CachedUpdates mode, please make a small example without using the CachedUpdates mode and send it to us using the contact form https://devart.com/company/contactform.html, including scripts for creating and filling database objects.

gss200610
Posts: 35
Joined: Mon 23 May 2016 22:29

Re: how to use aggregates fields with unidac and firebird? any example?

Post by gss200610 » Tue 27 Feb 2018 12:05

uniquery has support for aggregate fields ?, tried in several ways and always says that it is not possible to execute

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: how to use aggregates fields with unidac and firebird? any example?

Post by ViktorV » Tue 27 Feb 2018 12:30

In order for us to be able to give you a detailed answer, we need to have a sample demonstrating the specified behavior. Therefore, please compose a small sample demonstrating the described behavior and send it to us using the contact form https://devart.com/company/contactform.html, including the scripts for creating database objects.

Post Reply