Printable View
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
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
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
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
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
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
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