Three Questions...

[Ruslan Zasukhin]

on 11/25/03 1:06 AM, Ken Ray at kray at sonsothunder.com wrote:

Hi Ken,

> Question #2:
> 
> Many versions of SQL allow for inline functions to be part of the
> WHERE clause. Valentina supports Method fields to store calculated
> results that can be retrieved, but it although we can have a Method
> field called "ModifiedMonth" that had the calculation
> "MONTH(ModifiedDate)" which we can call as "SELECT Entities.ModifiedDate
> WHERE ModifiedMonth=2", but the inline SQL call "SELECT
> Entities.ModifiedDate WHERE MONTH(ModifiedDate)=2" doesn't work. Any
> idea when Valentina will support inline functions like this so that we
> won't need to use Method fields all the time?

This will works in 2.0

This already works in our tests.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------