SQL question

[Ruslan Zasukhin]

On 11/9/04 8:25 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

> Hi!
> 
> I am trying to find all dates in a table which belong to a specific month,
> independet from day and year (eg. Find all born in may). I have tried
> something like
> 
> x=VALselectReturnCursor("SELECT * FROM KUNDENTable WHERE MONTH(geburtsdatum)
> = '05'")
> 
> in a 100 different ways with different positions, brackets etc, but I always
> get errors like 616...
> 
> Is there a solution to this?

Florian,

You have forget that you cannot use funcs directly in SQL.
You need BaseObject method


Also you can use 
    f LIKE '../05/....'


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