Hi
what i was trying to do is, i am using Dataset to populate data and update the database. The problem is i have a column which is of type Varchar(1), doesn't accept Nulls and default value is 0
when i insert a row through SQL and if i don't enter any value, it inserts 0 but when i try to do the same using Dataset it doesn't seem to be picking the default value and displaying an error message "A value must be entered in the column"
Can someone please advise about how to make dataset insert mentioned default value if we don't provide a value to the column
Please let me know if you need more info
thanks heaps
Sri
what i was trying to do is, i am using Dataset to populate data and update the database. The problem is i have a column which is of type Varchar(1), doesn't accept Nulls and default value is 0
when i insert a row through SQL and if i don't enter any value, it inserts 0 but when i try to do the same using Dataset it doesn't seem to be picking the default value and displaying an error message "A value must be entered in the column"
Can someone please advise about how to make dataset insert mentioned default value if we don't provide a value to the column
Please let me know if you need more info
thanks heaps
Sri