[RESOLVED] inserting into database

[elixir_5000]

i am using a normal inert into statement to insert the data into the access database but theree are some cases in which i need to leave the text box blank then the insert statement gives error can u tell me the method of inserting a blank value that is if the text box has the value that is inserted else blank is inserted

[michaelrawi]

What error ? AFAIK, textbox will have an empty string if you don't input anything. So, there should be no problem if you leave a textbox empty, unless the field that you want to insert is a primary key.

[elixir_5000]

i dont know wats happening but if i leave any of the text box empty then there is an error data type mismatch else it is ok

[elixir_5000]

plz some one help me out

[warrenayen]

Well that would suggest the fields don't allow Null values, for one. For two, are you opening the connection before sending the data?

[stanav]

If the fields in your access table do not allow null, then you can't insert a null value to it.... So you need to find out the specs for that table, things like field names and data types, allows null or not.... If any field that does not allow null, then you have to supply a default value for that field.

[purpleant]

You could set the value of the textbox to a space (" ") if nothing is input, and this would keep you from having to change the null state on the field, if you are hesitant to do that.

Hope this helps,
Brian Swanson

[stanav]

You could set the value of the textbox to a space (" ") if nothing is input, and this would keep you from having to change the null state on the field, if you are hesitant to do that.

Hope this helps,
Brian Swanson

This works only if that field's data type is string... What if the field is numeric or date?

[purpleant]

I figured it was a safe assumption based on the fact that a textbox was being used and the question being asked that it was a string.

[gajalakshmi]

i am using a normal inert into statement to insert the data into the access database but theree are some cases in which i need to leave the text box blank then the insert statement gives error can u tell me the method of inserting a blank value that is if the text box has the value that is inserted else blank is inserted