Results 1 to 7 of 7

Thread: Update columns with NULL Values

  1. #1
    Alan Hill Guest

    Update columns with NULL Values

    I`m using ASP-db Pro to edit (Add/Change) records to SQL Server 6.5 tables. However, I cannot put NULL values in columns with Int and Date data types. The records need to have NULL value until such time as there are valid values for them. Is anyone else having this problem? Is there a solution?

    Thanks,
    Alan

  2. #2
    Frank Guest

    Update columns with NULL Values (reply)

    Alan,
    I have to look in to this one. Meanwhile does inputting NULL or `NULL` has any effect ?

    Frank

    On 9/16/98 2:27:06 PM, Alan Hill wrote:
    > I`m using ASP-db Pro to edit (Add/Change) records to SQL Server 6.5 tables.
    > However, I cannot put NULL values in columns with Int and Date data types.
    > The records need to have NULL value until such time as there are valid
    > values for them. Is anyone else having this problem? Is there a
    > solution?

    Thanks,
    Alan

  3. #3
    Alan Hill Guest

    Update columns with NULL Values (reply)

    I tried NULL, `NULL` and "NULL". No success. Allow NULLS is checked in the SQL Server database. The datatypes in this table are int, varchar, and bit.
    The aspbd properties are:
    CommDb.dbNavigationItem="bottom,prev,next,bottom,r eload,edit"
    CommDb.dbEditParams="TableName=tblComminfo, BookMarkFlds=ThumbID, RecordScope=Single, BooleanAsBit=True"
    CommDB.dbOptions="DateWrap=`"

    Alan


    On 9/16/98 7:07:46 PM, Frank wrote:
    > Alan,
    I have to look in to this one. Meanwhile does inputting NULL or
    > `NULL` has any effect ?

    Frank

    On 9/16/98 2:27:06 PM, Alan Hill wrote:
    >
    > I`m using ASP-db Pro to edit (Add/Change) records to SQL Server 6.5
    > tables.
    > However, I cannot put NULL values in columns with Int and Date
    > data types.
    > The records need to have NULL value until such time as
    > there are valid
    > values for them. Is anyone else having this problem?
    > Is there a
    > solution?

    Thanks,
    Alan

  4. #4
    Frank Guest

    Update columns with NULL Values (reply)

    Alan,
    Can you pick out a table in "pubs" example to illustrate the problem. Meanwhile, I`ll do some experiemtent with NULL in int/date fields. It might just be accepting the NULL as a NULL and not a varchar inthe int and date field.

    Frank


    On 9/17/98 6:37:25 AM, Alan Hill wrote:
    > I tried NULL, `NULL` and "NULL". No success. Allow NULLS is checked in the
    > SQL Server database. The datatypes in this table are int, varchar, and
    > bit.
    The aspbd properties
    > are:
    CommDb.dbNavigationItem="bottom,prev,next,bottom,r eload,edit"
    CommDb.
    > dbEditParams="TableName=tblComminfo, BookMarkFlds=ThumbID,
    > RecordScope=Single,
    > BooleanAsBit=True"
    CommDB.dbOptions="DateWrap=`"

    Alan


    On 9/16/98
    > 7:07:46 PM, Frank wrote:
    > Alan,
    I have to look in to this one.
    > Meanwhile does inputting NULL or
    > `NULL` has any effect ?

    Frank

    On
    > 9/16/98 2:27:06 PM, Alan Hill wrote:
    >
    > I`m using ASP-db Pro to edit
    > (Add/Change) records to SQL Server 6.5
    > tables.
    > However, I cannot
    > put NULL values in columns with Int and Date
    > data types.
    > The
    > records need to have NULL value until such time as
    > there are valid
    >
    > values for them. Is anyone else having this problem?
    > Is there a
    >
    > solution?

    Thanks,
    Alan

  5. #5
    Frank Guest

    Update columns with NULL Values (reply)

    Alan,
    I went into "pubs" "authors" table, the address, city , zip and state are all Nulls accepted. I edit/update a record it and left the Zip and state as blank and it works. Try with a blank. I think I have to offer a better user edit control like EditBlank=Null. I`ll put this in the next release. So, try the blank and let me know how it turns out.

    Frank

    On 9/17/98 6:37:25 AM, Alan Hill wrote:
    > I tried NULL, `NULL` and "NULL". No success. Allow NULLS is checked in the
    > SQL Server database. The datatypes in this table are int, varchar, and
    > bit.
    The aspbd properties
    > are:
    CommDb.dbNavigationItem="bottom,prev,next,bottom,r eload,edit"
    CommDb.
    > dbEditParams="TableName=tblComminfo, BookMarkFlds=ThumbID,
    > RecordScope=Single,
    > BooleanAsBit=True"
    CommDB.dbOptions="DateWrap=`"

    Alan


    On 9/16/98
    > 7:07:46 PM, Frank wrote:
    > Alan,
    I have to look in to this one.
    > Meanwhile does inputting NULL or
    > `NULL` has any effect ?

    Frank

    On
    > 9/16/98 2:27:06 PM, Alan Hill wrote:
    >
    > I`m using ASP-db Pro to edit
    > (Add/Change) records to SQL Server 6.5
    > tables.
    > However, I cannot
    > put NULL values in columns with Int and Date
    > data types.
    > The
    > records need to have NULL value until such time as
    > there are valid
    >
    > values for them. Is anyone else having this problem?
    > Is there a
    >
    > solution?

    Thanks,
    Alan

  6. #6
    Alan Hill Guest

    Update columns with NULL Values (reply)

    Blanks don`t work for me. I also went into "pubs", "employee" table and changed "hire_date", which is a "datetime" data type, to allow nulls. When I edited "hire_date" with asp-db Pro and changed a hire_date to a blank or deleted everything in the editbox, I got the error message: "Incorrect data type - [hire_date = ]" when I update.

    Note that in your test, the data types are all char or varchar, NOT datetime or int.

    Alan



    On 9/17/98 8:32:59 PM, Frank wrote:
    > Alan,
    I went into "pubs" "authors" table, the address, city , zip and
    > state are all Nulls accepted. I edit/update a record it and left the Zip
    > and state as blank and it works. Try with a blank. I think I have to offer
    > a better user edit control like EditBlank=Null. I`ll put this in the next
    > release. So, try the blank and let me know how it turns out.

    Frank

    On
    > 9/17/98 6:37:25 AM, Alan Hill wrote:
    > I tried NULL, `NULL` and "NULL".
    > No success. Allow NULLS is checked in the
    > SQL Server database. The
    > datatypes in this table are int, varchar, and
    > bit.
    The aspbd
    > properties
    >
    > are:
    CommDb.dbNavigationItem="bottom,prev,next,bottom,r eload,edit"
    CommDb.
    >
    > dbEditParams="TableName=tblComminfo, BookMarkFlds=ThumbID,
    >
    > RecordScope=Single,
    >
    > BooleanAsBit=True"
    CommDB.dbOptions="DateWrap=`"

    Alan


    On 9/16/98
    >
    > 7:07:46 PM, Frank wrote:
    > Alan,
    I have to look in to this one.
    >
    > Meanwhile does inputting NULL or
    > `NULL` has any effect ?

    Frank

    On
    >
    > 9/16/98 2:27:06 PM, Alan Hill wrote:
    >
    > I`m using ASP-db Pro to
    > edit
    > (Add/Change) records to SQL Server 6.5
    > tables.
    > However, I
    > cannot
    > put NULL values in columns with Int and Date
    > data types.
    >
    > The
    > records need to have NULL value until such time as
    > there are
    > valid
    >
    > values for them. Is anyone else having this problem?
    > Is
    > there a
    >
    > solution?

    Thanks,
    Alan

  7. #7
    Frank Guest

    Update columns with NULL Values (reply)

    Alan,
    I can dup the problem now... wait for the fix. I`ll see whetehr I can allow a blank as to bypass the field and the work NULL to make it a NULL.

    Frank


    On 9/18/98 11:19:54 AM, Alan Hill wrote:
    > Blanks don`t work for me. I also went into "pubs", "employee" table and
    > changed "hire_date", which is a "datetime" data type, to allow nulls. When
    > I edited "hire_date" with asp-db Pro and changed a hire_date to a blank or
    > deleted everything in the editbox, I got the error message: "Incorrect data
    > type - [hire_date = ]" when I update.

    Note that in your test, the data
    > types are all char or varchar, NOT datetime or int.

    Alan



    On
    > 9/17/98 8:32:59 PM, Frank wrote:
    > Alan,
    I went into "pubs" "authors"
    > table, the address, city , zip and
    > state are all Nulls accepted. I
    > edit/update a record it and left the Zip
    > and state as blank and it
    > works. Try with a blank. I think I have to offer
    > a better user edit
    > control like EditBlank=Null. I`ll put this in the next
    > release. So, try
    > the blank and let me know how it turns out.

    Frank

    On
    > 9/17/98
    > 6:37:25 AM, Alan Hill wrote:
    > I tried NULL, `NULL` and "NULL".
    > No
    > success. Allow NULLS is checked in the
    > SQL Server database. The
    >
    > datatypes in this table are int, varchar, and
    > bit.
    The aspbd
    >
    > properties
    >
    >
    > are:
    CommDb.dbNavigationItem="bottom,prev,next,bottom,r eload,edit"
    CommDb.
    >
    >
    > dbEditParams="TableName=tblComminfo, BookMarkFlds=ThumbID,
    >
    >
    > RecordScope=Single,
    >
    >
    > BooleanAsBit=True"
    CommDB.dbOptions="DateWrap=`"

    Alan


    On 9/16/98
    >
    >
    > 7:07:46 PM, Frank wrote:
    > Alan,
    I have to look in to this one.
    >
    >
    > Meanwhile does inputting NULL or
    > `NULL` has any effect
    > ?

    Frank

    On
    >
    > 9/16/98 2:27:06 PM, Alan Hill wrote:
    >
    > I`m
    > using ASP-db Pro to
    > edit
    > (Add/Change) records to SQL Server 6.5
    >
    > tables.
    > However, I
    > cannot
    > put NULL values in columns with Int
    > and Date
    > data types.
    >
    > The
    > records need to have NULL value
    > until such time as
    > there are
    > valid
    >
    > values for them. Is
    > anyone else having this problem?
    > Is
    > there a
    >
    >
    > solution?

    Thanks,
    Alan

Posting Permissions

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