select hour(timefield) as 'f1' from table1 group by f1

[Ivan Smahin]

Hello Joseph,

Wednesday, October 17, 2007, 4:25:11 PM, you wrote:

> On Oct 17, 2007, at 2:50 AM, Ivan Smahin wrote:

>> Try this:
>> select hour(timeField) as 'f1' from table1 group by f1

> I get this error:
> 08:22:47: Error: Kernel error: 0x51500. Identifier "f1" is not found.

> It should work, but it is not.
> Any suggestions

Could you report it to Mantis please?

Workaround:
Add   field-method   to   the   table   table1.   Method   text  is  -
hour(timeField).

Now your query will look like this:
select m1 from table1 group by m1


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com