Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: test if a datetime field is empty on SQL
Thread ID: 248690 Message ID: 248708 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 22, 2009 12:48:31 PM         
   


Stefan,

> Try Empty( Nvl(myField_Date, {}) )
This code works while inside VFP. What I want is to work on SQL Server, not VFP.

Regards,
Nilson

ENTIRE THREAD

test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 10:45:58 AM
RE: test if a datetime field is empty on SQL Posted by Borislav Borissov @ 12/22/2009 11:11:55 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 12:46:52 PM
RE: test if a datetime field is empty on SQL Posted by Borislav Borissov @ 12/22/2009 2:29:32 PM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/23/2009 5:00:37 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/23/2009 5:00:39 AM
RE: test if a datetime field is empty on SQL Posted by Stefan Wuebbe @ 12/22/2009 11:16:38 AM
RE: test if a datetime field is empty on SQL Posted by Nilson Rishi @ 12/22/2009 12:48:31 PM
RE: test if a datetime field is empty on SQL Posted by Stefan Wuebbe @ 12/22/2009 4:11:41 PM