Checking for null date

Steve Albin steve at steve-albin.com
Sun Mar 29 13:18:19 CDT 2009


I'm using V4RB 4 and I need to know how to tell if a date field in a cursor is null.  

I tried this:

  if VDateTime(cursor.Field(27)).Value <> nil then
    Return  VDateTime(cursor.Field(27)).Value
  else
    Return nil
  end
 
This returns a date field, but an invalid date which I would expect since I know the field is <NULL>.

I tried this:

  if  self.cursor.Field(27).GetString <> "" then
    Return  VDateTime(cursor.Field(27)).Value
  else
    Return nil
  end
    
This returns nil as expected.  

I can easily change my code to check the string value, but it seems that the first way should work.  What am I doing wrong?

Steve

-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/


More information about the Valentina mailing list