Year() function in select statement

[Ruslan Zasukhin]

on 2/20/04 7:43 PM, Gary Edge at valentina at panamind.com wrote:

> I'm trying to select and group by the year of a date field in a sql
> statement.
> 
> I try: "select year(date_released), count(*) from atable group by
> year(date_released)"
> 
> and I get a nil cursor.
> 
> Even without the grouping I get a nil cursor. When using just "select
> date_released ..." it works. Anyone advice on the correct way to use
> the year() function in a select statement?

Hi Gary,

This is FAQ.

You need create BaseObject method field,
And use it in SELECT


-- 
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
-------------------------------------------------------------