[Babase] Re: demog_census null status error
Karl O. Pinc
kop at meme.com
Tue Feb 19 14:16:49 EST 2008
On 02/19/2008 12:26:43 PM, kfenn wrote:
> Thanks Karl. I will test this as soon as I get the chance.
> Any ideas why it worked for some of the data (when grp and reference
> matched AND the group was in the census) but not for other data?
Yes. Because when the individual is already censused in the group
then the view does not need to insert a new census row, and it does
not need to do anything with the Status column because the triggers
automatically make whatever changes are needed. (I.e. 'A' -> 'D')
So, in that case the supplied Status value is ignored. Otherwise
the view would put the supplied status (which wasn't
given and so was NULL) into Status and we got the error.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list