×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Empty dates returned by remote view as 12/30/1899

Empty dates returned by remote view as 12/30/1899

Empty dates returned by remote view as 12/30/1899

(OP)
When I use a remote view to access a VFP6 table the sql returns an empty date field with the date 12/30/1899 rather than empty.  Can anyone tell me how I resolve this problem?

RE: Empty dates returned by remote view as 12/30/1899

  Use .NULL. values for empty date rather than SQL empty date. This also require some effort in VFP to check for .NULL. values, as well as set appropriate properties of controls to do not display 'NULL' when date is empty.
  If that date field is read-only, use expression in query and return character string instead of date data type, which will convert date to its string representation, or return empty string when date is empty on SQL serevr.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close