Results 1 to 2 of 2

Thread: [RESOLVED] Problem in fields that are saved with no values

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2004
    Posts
    1,414

    Resolved [RESOLVED] Problem in fields that are saved with no values

    Hi to all:

    In my database i had define a few fields with the format "Date/time".

    When i save values in this fields sometimes they not have nothing, that mean blanc fields.

    Well, when i try to work with this fields in mode EDIT, i had see the VBNet return values like this:
    "#12:00:00 AM#" (looks like a standard of the field??)

    Question: This is normal? Fields that are saved with nothing returned values???

    How can I resolve this kind of think? Because i would like the fields return nothing (blanc fields)

    Thanks to all

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,936

    Re: [RESOLVED] Problem in fields that are saved with no values

    When editing "nothing"/"null" values, it is normal for lots of different editing controls to show a default value for that field instead - which might be 0 for numbers, or "#12:00:00 AM#" for date/time values, etc.

    In most cases that is simply so you have a hint or template, to help you enter the value you want.

    If you want to force them to be blank, how you would do it depends on the control you are using, and possibly how you are filling the control.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width