I am attempting to use a parameterized query whereby I select based on a
parameterized year.  The parser trips on:

SELECT * From Schedule WHERE EXTRACT(Year From StartDate) = :YR ORDER BY
StartDate;

Is there a problem with my syntax, or is DBIsam just incapable of using a
parm with EXTRACT?

Thanks.

<< I am attempting to use a parameterized query whereby I select based on a
parameterized year.  The parser trips on:

SELECT * From Schedule WHERE EXTRACT(Year From StartDate) = :YR ORDER BY
StartDate;

Is there a problem with my syntax, or is DBIsam just incapable of using a
parm with EXTRACT? >>

Two things:

1) This is the ElevateDB newsgroup
2) What version of DBISAM are you using ?  I tried a similar query here and
it works just fine with 4.25 B7.

--
Tim Young
Elevate Software
www.elevatesoft.com