O$: Today in Frontbase

[jock at visionchips.com]

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