O$: Today in Frontbase

jock at visionchips.com jock at visionchips.com
Fri Apr 24 11:19:30 EDT 2009

Well, for me, today is so yesterday that I don't have a use for it


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


Mike Matthews

Manage your list subscriptions at http://lists.omnis-dev.com

Sent from my Verizon Wireless BlackBerry

More information about the omnisdev-en mailing list