In the docs, I see that FieldBetweenPredicate supports:

Field between value1 and value2 Field between value1 and anotherField Field between somefield and value2

However, what I am attempting is:

value between somefield and anotherfield

Is this possible - and if not, perhaps can get that on the todo list?

Of course we can work around this by not using the between clause for now...

Please refer to the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=6462

A value compared to fieldS isn't a field...predicate anymore .

Use 2 comparevalue predicates.

A value compared to fieldS isn't a field...predicate anymore.

Technicalities, technicalities...

I am always looking at it from - here is some sql I want to write - so, I try to get llblgen to be able to generate it.

Would be cool to add this functionality....

Thanks!

WayneBrantley wrote:

A value compared to fieldS isn't a field...predicate anymore.

Technicalities, technicalities...

I am always looking at it from - here is some sql I want to write - so, I try to get llblgen to be able to generate it.

Understandable, but it also IMHO makes understanding the framework more difficult, as it's not a 1:1 projection of SQL