How to Set Allow Zero Length for Field using OLEDBCommand
-
Hope this helps: http://www.dmxzone.com/go/5314/allow-zero-length-and-sql-create-alter-table/[^]
djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.
-
Hmm not really I am not using ADOX. I was hoping to just change the sql statement somehow. I am just using standard OleDbConnection
By the looks of it, it can't be done via a SQL script. If you set the column to "NOT NULL" rather than "NULL", that should allow zero-length values. Will that be feasible, or do you absolutely have to allow both NULL and zero-length?
djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.
-
By the looks of it, it can't be done via a SQL script. If you set the column to "NOT NULL" rather than "NULL", that should allow zero-length values. Will that be feasible, or do you absolutely have to allow both NULL and zero-length?
djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.
-
I have to allow both. "So simply but yet so hard" I guess I could always create a ADOX wrapper but I don't really want to go that way
-
May be your only option. Google it. I searched around and everything I found said that it's not possible via a SQL query script to allow NULL and zero-length.
djj55: Nice but may have a permission problem Pete O'Hanlon: He has my permission to run it.
-
Yeah I found the same thing when I Google it. I was hoping there was some bckdoor found by some of the GURU's here. Thanks for you help though.
-
-
You could write a trigger to do the validation. Not sure, but might also be done with a constraint that validates the length. --edit; I don't think that Access would allow the constraint-construction, I was thinking in Sql Server again. Still, Access does support triggers[^].
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
You could write a trigger to do the validation. Not sure, but might also be done with a constraint that validates the length. --edit; I don't think that Access would allow the constraint-construction, I was thinking in Sql Server again. Still, Access does support triggers[^].
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
Ahhh! Am I right Eddy that there is some limitations on triggers? I thought I saw something that said you could only use framework 2, 3 or 3.5. I believe I did anyways. I would like to stick with 4.5.
gwittlock wrote:
Am I right Eddy that there is some limitations on triggers?
Not that I know, but that hardly means anything; I don't use Access that often nowadays.
gwittlock wrote:
I would like to stick with 4.5.
The trigger would be in the database, not in the code :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]