[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