[Babase] More on FoxPro queries for testing
Catherine Markham (amarkham@Princeton.EDU)
babase@www.eco.princeton.edu
Wed, 10 Nov 2004 13:27:56 -0500
Hi,
This is follow-up to my last message about the FoxPro queries needed for testing. To better archive the information on the Babase listserv, I'm simply listing the queries below. Again, these queries are for all Babase tables, with the exception of SexSkins, for the purpose of comparing the new and old systems.
Catherine
select birth, bstatus, sex, matgrp, pid, sname, name, statdate, status, dcause, matured, mstatus, ranked, consorted, dispersed from biograph order by sname, pid to file biograph noconsole
select pid, parity, conceive, resume from pregs order by pid to file pregs noconsole
select cid, sname, seq, mdate, emdate, lmdate, tdate, etdate, ltdate, ddate, eddate, lddate from cycles order by cid to file cycles noconsole
select cenid, date, sname, grp, status, cen from census order by cenid to file census noconsole
select sname, role, iid from parts order by iid, role to file parts noconsole
select cenid, reference, comment from demog order by cenid to file demog noconsole
select iid, sid, act, date, start, stop, datetime from interact order by iid to file interact noconsole
select sname, date, grp, origin, interp from members order by sname, date to file members noconsole
select sname, rnkdate, grp, rnktype, rank from ranks order by sname, rnkdate, grp, rnktype to file ranks noconsole
select gid, name, from_group, permanent, supergroup from groups order by gid to file groups noconsole
select rid, date, sname, state, dins, dr, cids, cide, pid from repstats order by rid to file repstats noconsole
select csid, date, sname, state, dins, dr, cids, cide from cycstats order by csid to file cycstats noconsole
select sid, date, observer, grp, sname, mins, miniss, setupid, psionid from samples order by sid to file samples noconsole
select jpid, sid, activity, posture, time, foodcode, datetime from jpsamps order by jpid to jpsamps noconsole
select jpid, sname, code, unkid from jpneighbors order by jpid, code to jpneighbors noconsole
select fpid, sid, activity, posture, kidcontact, kidsuckle, time, foodcode, datetime from fpsamps order by fpid to fpsamps noconsole
select fpid, sname, code, unkid from fpneighbors order by fpid, code to fpneighbors noconsole
select act, descr, class, old from acts order by act to file acts noconsole
select status, descr from statuses order by status to file statuses noconsole
select bstatus, descr from bstats order by bstatus to file bstats noconsole
select mstatus, descr from mstats order by descr to file mstats noconsole
select dcause, descr from dcauses order by dcause to file dcauses noconsole
select rnktype, descr, query from rnktypes order by rnktype to file rnktypes noconsole
select sid, time, txt from adlibs order by sid, time, txt to file adlibs noconsole