When I write a dataset into an Oracle datasbase, I get an error when the
field is empty.
i.e.: one datarow has 3 fields, first one is a number, the second one is a
string and the third one is empty.
It is empty in the way that I put a "" in it, so it is a string, but an
empty one.
When I update the database table with this table I get an error.
If I put "0" in place of "" then there is no problem, I then I get a lot of
0's instead of empty cells in my grid.
The fields are all set on NVARCHAR2.
What can I write in the field so that the UPDATE command will except it and
not write the field as a DBNULL?
rg,
Eric
|