Problems with NULL


Author
Message
Howard Bennett
Howard Bennett
StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)StrataFrame Novice (65 reputation)
Group: Forum Members
Posts: 57, Visits: 496
I'm using DDT to setup a new database.  When I started I uncheked "Allow Null default value."  Don't know why - just thought that's what I was supposed to do...

I was able to setup my table and put fields on a form - no problems. 

I decided to add a couple of fields and the deployment to the server fails - b/c "Allow Null" is not checked (like the other fields.)  If I check the field - the deployment works - but the app fails with a "Conversion from type 'DBNull' to type 'String' is not valid."

Just need someone to tell me where I messed up and how to fix it - thanks!

HB

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Howard Bennett - 16 Years Ago
Ivan George Borges - 16 Years Ago
Greg McGuffey - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Howard Bennett - 16 Years Ago
                         Correct. You really don't want to allow null values within a database...
Trent L. Taylor - 16 Years Ago
                             Thanks for the help...again...
Howard Bennett - 16 Years Ago
                                 No problem :)
Trent L. Taylor - 16 Years Ago
             Okay - that did the trick - thanks!
Howard Bennett - 16 Years Ago
Howard Bennett - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search