YEAR() and MONTH() not working...?

[Ruslan Zasukhin]

on 2/21/03 8:14 PM, Michael Geary at listmail at gearyweb.com wrote:

> Aargh.
> 
> Okay, how do I use BaseObject methods? I've never done this before...
> Can you give me an example?

What API you use ?

IF you have see FileMaker, then our BaseObject methods is the same as
Calculation fields in FM.

This is very simple.
BaseObject method this is like function in other languages.
IT CALCULATE its value on the fly.

So if return to your task

You need create in table ULONG 'fldYear' field, and specify for it Formula
as

    "Year(fldDate)"

Now you can use it in SQL as

    SELECT fldYear, ...

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------