PC Review


Reply
Thread Tools Rate Thread

NULL problem

 
 
EMW
Guest
Posts: n/a
 
      17th Mar 2004
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Null = 0 Problem That Crazy Hockey Dood Microsoft Access 1 30th Jan 2009 02:20 PM
Parameter Query Problem (Null or Not Null) Antavas Microsoft Access Queries 3 9th Sep 2008 08:40 PM
IF IS NULL PROBLEM =?Utf-8?B?VGVyaQ==?= Microsoft Excel Worksheet Functions 3 25th Feb 2005 09:14 PM
Null problem aculfa Microsoft ADO .NET 5 9th Jan 2004 03:49 PM
Null result when combining null field with non-null field in ADP View Lauren Quantrell Microsoft Access Form Coding 8 17th Nov 2003 03:34 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:43 PM.