-
May 13th, 2013, 04:59 PM
#1
Thread Starter
Fanatic Member
Database text field. Allow Zero Length Yes/No
In jet databases. Text columns have an option "Allow Zero Length" which can be set Yes or No.
Has the behaviour changed? In my vb6 application If "Allow Zero Length=No" then an empty string is allowed but null isnt. So, using an sql INSERT naming all fields and inserting '' empty strings into each field is no problem.
But in .Net Oledb/jet4 an empty string is not allowed. The string has to contain 1 or more characters.?
Is that right or is something else going on?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|