MyFiles

Below are listed the the files I have stored here.  If you want to to understand how to use them go to Accessing the Kedit, SQL, and GEDCOM Files.

Kedit Macros

FTPerson.kex
     The macro for creating the sql to load the Person Table.

FTPersonEvent.kex
     The macro for creating the sql to load the PersonEvent Table.

FTPersonFamily.kex
     The macro for creating the sql to load the PersonFamily Table.

PROFILE.KEX
      Store this in the Kedit folder. This configures Kedit every time it loads.

SQL Tables
These each will load the named sql Table

Create Country Table.sql

Create Event Table.sql

Create EventType Table.sql

Create FamilyRole Table.sql

Create Sex Table.sql

Create State Table.sql

SQL Views
Each of these extracts from the SQL data tables data
that corresponds to the title of the view

vwCompleteFamilyGroup.sql

vwFamiliesPeopleBelongTo.sql

vwFamilyGroup.sql

vwMultipleBDEvents.sql

vwMultipleNames.sql

vwPartners.sql

vwPersonEventCounts.sql

vwPersonParentCount.sql

vwWrongParentCount.sql

vwWrongParentList.sql

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s