-- "NIPP, SCOTT V \\(SBCSI\\)" <[EMAIL PROTECTED]>
OK... I have been able to solve this problem, and it was no big
deal. However, the problem I am currently facing is really hosing me
up... Basically, a "NULL" field is getting converted to a 0 in the
database. This causes a comparison of the same file and the database to
yield a lot of differences. Please help. I think this has got to be
related to the INSERT. The table column is setup as 'smallint' allowing
NULLS with the default value set to NULL. This column however is
getting a '0' if the input file is empty for that field.
Here is the pertinent code...
Simple fix: Don't store NULL's in your database. If you pick
an appropriate non-NULL value then the entire problem goes
away and you can tell what the outcome of joins really is.
--
Steven Lembark 85-09 90th Street
Workhorse Computing Woodhaven, NY 11421
[EMAIL PROTECTED] 1 888 359 3508
