Posts   
 
    
Posts: 15
Joined: 01-Oct-2003
# Posted on: 02-Oct-2003 17:43:32   

Is there a way to construct a predicate expression for things like MAX. I would be after the object (row) with the highest value for this column.

Is an SP the only way to go?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 02-Oct-2003 18:05:05   

I had to skip aggregate functions for the initial release due to time constraints. These will be added later (probably in december or even later). A view or stored procedure are, sadly, the current options you have. I regret not having them in the library (as you will have noticed, there is a grouped by clause implemented already but no aggregate function support) but they will be added, it depends on when I have time to do so. Priority no.1 is support for Oracle, firebird/interbase and Postgresql.

Frans Bouma | Lead developer LLBLGen Pro
bonder
User
Posts: 36
Joined: 23-Sep-2003
# Posted on: 03-Oct-2003 04:36:50   

Otis wrote:

I had to skip aggregate functions for the initial release due to time constraints. These will be added later (probably in december or even later). A view or stored procedure are, sadly, the current options you have. I regret not having them in the library (as you will have noticed, there is a grouped by clause implemented already but no aggregate function support) but they will be added, it depends on when I have time to do so. Priority no.1 is support for Oracle, firebird/interbase and Postgresql.

I would also cheer to get the aggregate functions, but for now it's easy enough to rely on sprocs to get the job done!

--Bruce

sparmar2000 avatar
Posts: 341
Joined: 30-Nov-2003
# Posted on: 19-Feb-2004 15:46:25   

Frans, Have you updated Pro since and included MAX functionality?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 19-Feb-2004 16:26:33   

Aggregates are not yet supported. Sorry. Expect them in Q2 2004 (april-june)

Frans Bouma | Lead developer LLBLGen Pro
sparmar2000 avatar
Posts: 341
Joined: 30-Nov-2003
# Posted on: 20-Feb-2004 14:18:19   

Thanks Frans. Look forward to it.

Gareth
User
Posts: 24
Joined: 09-Apr-2004
# Posted on: 09-Apr-2004 23:07:50   

Does this still look like these functions will be ready for April - June?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 09-Apr-2004 23:42:27   

Yes, with the next runtime revision, which is planned in May-june timeframe.

Frans Bouma | Lead developer LLBLGen Pro
Gareth
User
Posts: 24
Joined: 09-Apr-2004
# Posted on: 10-Apr-2004 00:15:50   

This will hopefully be just in time. I shall leave that bit of the project until then.