Wed, 18 Jun 1902 08:00:00 GMT

D4.TQuery.RequestLive - where Month(Date) = :MonthParam

It is given: D4 c/s, SQL Anywhere 5.5
-
I have a query:
-
SELECT DatePoluch, NNakl ,primech,Month(DatePoluch) as MonthPoluch
FROM DBA.zayavka zz
where dostavshik=:dostavshik
and (Month(DatePoluch) = :MonthPoluch)
and ...
order ...
-
The records in query must be updatable.
(RequestLive=True, UpdateSQL ....)
when I add condition (number of month):
and (Month(DatePoluch) = :MonthPoluch)
Than I have a Delphi errror:
Invalid use of keyword.
Token: Month(DatePoluch)
Line Number 4.
-
How to fix it?
--
Thanks...
klo...@tv-park.kiev.ua; (+38 044) 464-71-85, 464-71-78 - work
klo...@maile{*word*277}.com; http://klokov.conk.com - home