HnD | Help with a FilterBucket, Page 1

Help with a FilterBucket

Posts

omar
User

Posts: 569
Joined: 15-Oct-2004

# Posted on: 19-Jan-2006 11:08:21

Greetings all, I need to build a filterBucket for this SQL

Select * From SomeTable Where Year(SomeTable.SomeDate) = 2005

How can I build the expression Year(SomeTable.SomeDate) = 2005

Otis
LLBLGen Pro Team

Posts: 39933
Joined: 17-Aug-2003

# Posted on: 19-Jan-2006 11:37:33

Frans Bouma | Lead developer LLBLGen Pro

omar
User

Posts: 569
Joined: 15-Oct-2004

# Posted on: 20-Jan-2006 21:04:12

Great stuff Frans... I wonder why don't you make this FunctionExpression a standard part of LLBL.

One question, will this work with UDF (userDefinedFunctions) ??

Otis
LLBLGen Pro Team

Posts: 39933
Joined: 17-Aug-2003

# Posted on: 21-Jan-2006 11:42:46

It will (but more sophisticated ). It will work with UDFs too.

Frans Bouma | Lead developer LLBLGen Pro