[Babase] demog_census null status error seems fixed
kfenn
kfenn at princeton.edu
Mon Feb 25 09:52:06 EST 2008
Karl O. Pinc wrote:
>
> 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: I used the upload program to get a demog note on SHO into
demog_census. Your fix worked. SHO has a different reference and grp
number and was not part of any regular group, but the upload went fine.
One annoying thing: If I successfully upload a file into babase_test
first, then try to upload the same file into babase, I get the error
message:
Upload aborted. A file with this name was just successfully loaded into
the database.
I have to logout and restart the program to be able to upload a file
with the same name. If this is an easy fix, it would be nice to have it
recognize that I'm using two different databases so it doesn't complain
to me, but don't go to any trouble over it.
Tabby
> Karl <kop at meme.com>
> Free Software: "You don't pay back, you pay forward."
> -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
--
Tabby Fenn
Research Assistant
Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ 08544
609 258-6898 (Ph)
609 258-2712 (Fx)
More information about the Babase
mailing list