Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 128
  • Last Modified:

How to manage dates in Delphi/SQL

I have made an IntrBase Database in Delphi. I will list only the records where a datefield is empty. I have made the following command:
SELECT * FROM BOOKS
WHERE DATEFIELD <> ' '
but this don't work. What do I wrong?
0
scones
Asked:
scones
1 Solution
 
RBertoraCommented:
Hi there, I am unsure of what it is exactly that you want to do
but may I suggest this:

DateField is NULL
or DateField is not Null

Hope it is usefull..
Rob.
0
 
sconesAuthor Commented:
Thank you very much Rob for this info.
Anton
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now