Simple COUNT

BIZ TMS Aurelius
1

Hi, I'm new in Aurelius.

Please can anyone explain me how can I do this with Aurelius
"SELECT COUNT(*) FROM myTable"

Many thanks.
2

Have you checked projections?


http://www.tmssoftware.biz/business/aurelius/doc/web/results_with_projections.htm

3

Sorry, but I'm new in this forum.

When I ask a question, "please" post a reply and not another question.
If I ask a question is because I don't know that.
Thank you...
4

You can use projections like this:



Value := Manager.CreateCriteria<TmyTable>

   .SetProjections(TProjections.Sum('idfield'))

   .UniqueValue;



where TmyTable would be the entity type mapped to myTable and 'idfield' would be the id field of the object. You can find more information in the help, under queries\projections

5

Sorry, replace SUM with COUNT in previous example