O$: Today in Frontbase

[Mike Matthews]

Consider getting up earlier is my advice.

Mike

On 24 Apr 2009, at 16:19, jock at visionchips.com wrote:

> Well, for me, today is so yesterday that I don't have a use for it
>
> Jock
>
> ------Original Message------
> From: Mike Matthews
> Sender: omnisdev-en-bounces at lists.omnis-dev.com
> To: OmnisDev List - English
> ReplyTo: OmnisDev List - English
> Sent: Apr 24, 2009 8:12 AM
> Subject: O$: Today in Frontbase
>
> Hello FB users,
>
> After reading the docs a bit, I have tried to find the reserved word
> that means TODAY.  I have tried CURDATE but no joy.  I want to find
> all records with a DateTime field whose date part is TODAY.  It may be
> a mismatch with it being DateTime though.
>
> 'WHERE tablename.DIARY_DATE = [#D]' doesn't work in my fetchall.
>
> Any answers please?
>
> Thanks
>
> Mike Matthews
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>
>
> Sent from my Verizon Wireless BlackBerry
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com