Re: Genealogical evidence and data model

On Mon, 04 Feb 2008 09:13:38 -0500, Haines Brown
<brownh@[EMAIL PROTECTED]
> declaimed the following in
soc.genealogy.computing:

> Interesting; I remember FoxPro from back in the 90s. Is Microsoft
> dropping sup****t for it because VFP runs under wine? How will that
> affect TMG? It sounds like it is a relational database that has a table
> interface. Is that so?  I assume it is more than spreadsheets.
>
	Can't speak for M$, or even for the full VFP system -- as I
understand it, VFP is a full programming environment using some sort of
language to manipulate the data. The data tables themselves are a
variation of dBASE -- each "table" consisting of three files:
consolidated index (which probably has each key value with a list of
record numbers associated), a fixed-width data table (each record is the
same size, so one can calculate a position in the file from (record
number - 1) * record length, and a variable text file (for memo type
fields in the fixed length record -- the fixed record would have a
pointer to the memo text in the other file).

	Beyond that, yes -- a relational database system. As I think I
mentioned, using a VFP free-table directory ODBC connection, one can
im****t the tables into Access (but would then need to create the linking
relation****ps by hand).

	Legacy using JET (the database engine native to Access -- Access is
really just a form/re****t designer for JET, and in newer versions, SQL
Server/MSDE [access data project vs access data base]. With ODBC
connections, Access can be used with MySQL even -- though some
difficulty in some aspects.
-- 
	Wulfraed	Dennis Lee Bieber		KD6MOG
	wlfraed@[EMAIL PROTECTED]
(Bestiaria Sup****t Staff:		web-asst@[EMAIL PROTECTED]
)
		HTTP://www.bestiaria.com/