[Babase] Re: fecal tables
Karl O. Pinc
kop at meme.com
Mon Apr 9 18:42:56 EDT 2007
On 04/09/2007 03:46:30 PM, kfenn wrote:
> Hi Karl,
>
> I thought I send you an email about updating fecal tables for
> Laurence in the online babase....but I can't seem to find it in my
> SENT box. I'm thinking I did something weird and never sent it.
> Did you get anything like that from me last week...? If not, I will
> pose the question again here...
I don't recall anything.
>
> How difficult is it to add some tables to babase that are Laurence
> has maintained in FoxPro....there are two tables and they don't link
> to anything but themselves, I think.
There's some way to export them out of foxpro as text, but I forget
the details. Try looking up SELECT INTO in the foxpro docs?
You'll want either tab delimited or csv data, not just
sql's SELECT output. Or maybe there's some other foxpro
command, like COPY?
I can also convert dbf to text on papio, but I'd prefer to
convert _all_ the dbf's to text in one huge run than to work
piecemeal.
If you want them to be part of the official babase then I'd like
to look at the table layout, document it, etc. If all you want
is access from papio then you can either put the tables into
the sandbox schema yourself or I can make a schema just for
the two tables. The latter is probably best. IIRC, Leah asked
me to do the same for some of Susan's data and we created
several schema for various hunks of data.
We should really:
Document those schema in the wiki.
Show you and Lacey how to use your babase_admin superpowers
to make schema for cases like this. Oh, and then
document that on the wiki. :-)
If it's just Laurance's stuff you can help her make tables
in her own schema.
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