[Babase] Updating AMO's birthdate

Niki Learn nlearn at princeton.edu
Mon May 3 14:58:34 EDT 2010


Cool.  So with members still empty, I ran this in test and it worked:

select * from biograph where sname = 'BIL';
select * from biograph where sname = 'AMO';
update biograph set pid = 'BET5', birth = '1995-02-28', bstatus = 0, matgrp
= 3.00 where sname = 'AMO';
select * from biograph where sname = 'BIL';
select * from biograph where sname = 'AMO';

Lacey, I have a census file ready.  Maybe after tomorrow's babase call we'll
know how we should do the manual entries and we can go from there.


-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl O. Pinc
Sent: Friday, April 30, 2010 3:55 PM
To: babase at eeblistserv.Princeton.EDU
Subject: [Babase] Updating AMO's birthdate

Lacey and  Niki,

Apparently a query quite like the one below, with the rest
of the db the way it is, had never been run before.

update biograph set birth ='1995-02-28' where sname = 'AMO';

There was a bug in a piece of code that had clearly never
been run, the piece that interpolates around the birthdate
when you run this query.

I believe I've fixed the problem.  Please check the interpolation
results (in MEMBERS) for this individual after you run this
query to be sure it's interpolating as you expect.

Thanks.

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



More information about the Babase mailing list