Correct ANSI SQL syntax for filter

Discuss the HanDBase for Windows Desktop program, conduits, and add-ons.

Correct ANSI SQL syntax for filter

Postby Saintor » Wed Oct 27, 2010 2:21 pm

I would like to "specify a filter for the incoming records" in the "Handbase Data Exchange for ODBC" that excludes the records with today's date. The name of the field is "Date".

In Access [Date]<>Date() would work.

I don't know SQL but found this on internet

Not "Date" = DAY(GETDATE())
"Date" <> DAY(GETDATE())
"Date" < DAY(GETDATE())

Nothing passes unless there is no filter. Can somebody help on the syntax? TIA.
Saintor
 
Posts: 34
Joined: Mon Aug 30, 2010 8:13 pm

Re: Correct ANSI SQL syntax for filter

Postby curtterp » Thu Oct 28, 2010 5:06 am

Have you tried Date <> GETDATE()
Have a good day

Curt
I am not a DDHSoftware employee, just a long time HanDBase user.... from Palm to Windows Mobile to Android, to iOS. Thanks to DDH, the database files transferred to each platform without a problem.
curtterp
 
Posts: 679
Joined: Tue May 26, 2009 6:41 pm
Location: Northern IL


Return to HanDBase for Windows

Who is online

Users browsing this forum: Google [Bot] and 1 guest