Hi
I am inserting some records into my access database using asp.net vb script.
The problem is that "Username" is set to "Not Null" in my database and so i get the following message returned.
Microsoft JET Database Engine error '80004005'
The field 'CustomerOrder. Username' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/james/placeorder.asp, line 135
However, i have tested it and i am sure that i have a value in the field for "Username". I have done a query to retrieve this.
Heres the code:
<input name="Username" type="hidden" id="Username" value="<%=(Reco rdset2.Fields.I tem("Username") .Value)%>">
So if the value is present, why isnt it going into the table?!
Any help greatly appreciated.
thank you
I am inserting some records into my access database using asp.net vb script.
The problem is that "Username" is set to "Not Null" in my database and so i get the following message returned.
Microsoft JET Database Engine error '80004005'
The field 'CustomerOrder. Username' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/james/placeorder.asp, line 135
However, i have tested it and i am sure that i have a value in the field for "Username". I have done a query to retrieve this.
Heres the code:
<input name="Username" type="hidden" id="Username" value="<%=(Reco rdset2.Fields.I tem("Username") .Value)%>">
So if the value is present, why isnt it going into the table?!
Any help greatly appreciated.
thank you