[Babase] Minor census correction

Karl O. Pinc kop at meme.com
Thu May 31 12:30:11 EDT 2007


On 05/31/2007 10:54:06 AM, kfenn wrote:
> Karl O. Pinc wrote:
>> 
>> On 05/31/2007 10:36:02 AM, Karl O. Pinc wrote:
>> 
>>> The problem is that the census Status column was wrong.
>> 
>> So, the new system silently fixed it and we got no
>> conversion error, but did get a difference when
>> comparing against foxpro.
>> 
> So if it exists ONLY as a demog note, not as a census row in FoxPro,  
> will the new system upload it correctly to the census table (like  
> updemog does?)  Do I need those 'Absent' rows in the FoxPro census  
> table or not?

Yes, every DEMOG row needs a CENSUS row.  (As you noted,
updemog does this for you.  In the new system you'll use
my upload program and upload into the CENSUS_DEMOG view
and that will do it for you.)  In this case we really
want it because it has a Cen of 1 (true), there was a census
and the individual was marked absent.  (But the status becomes
D because there's also a demography note, so they're not
really absent they wind up in the group in MEMBERS.)

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