I have set defaults to all columns in previous jobs.
0," ",0001-01-01 for integer/decimal,varchar/char,date respectively.
In the current job i need to do a full outer join and check for New, changed, Delete, and Duplicate.
If i need to get the New Insert, i check for the previous defaults. But it is not working, so i checked for null still it is not woirking. so used the following code for that condition.
Code: Select all
Len(Trim(fieldname)) = 0
But when i need to check null condition for date, i got pissed off......
i could not use "", or IS NULL, or previous defaults.
I tried using Default, Null Feild Value, and with Nullable = yes.
If i need to equate both record feildname.1 = feildname.2 and if it is null the conditon works unexpectedly.
May i know how to check null for dates and other data type.
regards
kumar