Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 352636" data-attributes="member: 36373">1) The error message says that it doesn't have a default value, which means its in his table and hes trying to insert a query that is going to try to assign &quot;gotw_points&quot; NO VALUE. His Database doesn't allow that.2) He never said &quot;gotw_points&quot; was in his users table so don't just assume it is, and it is ALREADY in his table that he is trying to add.Ignore this moron who thinks he knows what he is doing. The correct way to fix this error is to open your database in design view, go down to the column and you can do one of two things:1) You can make it so that gotw_points can have no value by allowing Null. While this can be useful, it could also be bad depending on what gotw_points does so I would rather do option 2:2) You can set a default value, not sure what gotw_points does but I would set the default value = 0.</blockquote>

[QUOTE="JayC, post: 352636, member: 36373"] 1) The error message says that it doesn't have a default value, which means its in his table and hes trying to insert a query that is going to try to assign "gotw_points" NO VALUE. His Database doesn't allow that. 2) He never said "gotw_points" was in his users table so don't just assume it is, and it is ALREADY in his table that he is trying to add. Ignore this moron who thinks he knows what he is doing. The correct way to fix this error is to open your database in design view, go down to the column and you can do one of two things: 1) You can make it so that gotw_points can have no value by allowing Null. While this can be useful, it could also be bad depending on what gotw_points does so I would rather do option 2: 2) You can set a default value, not sure what gotw_points does but I would set the default value = 0. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members