Boffin Examples

The Dinosaur Database

Dino_Access_Email_Example1.sql

/* This example runs 3 queries and outputs them to one Access database called DINO.MDB as 3 separate tables called PERIODS, FEEDER_TYPE and DINOSAURS. The database and tables are created automatically. 
*/
/* NOTE - NO indexes are created on the Access tables. These can be added afterwards in Access as required */

/* Records that exist will be updated when they are altered and new records will be added */

/* NOTE always precede the query with the Spool commands making the query the last part of each block. Terminate each query with a semicolon (;) */

/* The Email address below will send you a reply to confirm that it is working */

Emailto= "test@boffin.org.uk"

-- there should be only one Email address. 
-- if there is more than one than the last one takes precedence.


SpoolAccess = "C:\Temp\Dino.mdb"
SpoolTable = "Periods"
Select 
DINO_PERIOD.PERIOD "Period",
DINO_PERIOD.PERIOD_DESCRIPTION "Description" 
From DINO_PERIOD 
Order by DINO_PERIOD.PERIOD;

SpoolTable = "Feeder_Type"
Select 
DINO_FEEDER.FEEDER "Type of Feeder",
DINO_FEEDER.FEEDER_MEANING "Meaning" 
From DINO_FEEDER 
Order by DINO_FEEDER.FEEDER;

SpoolTable = "Dinosaurs"
Select 
DINOSAURS.DINO_NAME "Name",
DINOSAURS.MEANING "Meaning",
DINOSAURS.PERIOD "Period",
DINOSAURS.LIVED "Lived",
DINOSAURS.FOUND "Found In",
DINOSAURS.BODY_LENGTH "Body Length (m)",
DINOSAURS.BODY_HEIGHT "Body Height (m)",
DINOSAURS.BODY_WEIGHT "Body Weight (kg)",
DINOSAURS.MOVED "Moves on",
DINOSAURS.FEEDER_TYPE "Type of Feeder",
DINOSAURS.FOOD "Eats",
DINOSAURS.DESCRIBED_BY "Described By",
DINOSAURS.YEAR_DESCRIBED "Year Described",
DINOSAURS.UPDATE_DATE "Last Updated On"
From DINOSAURS
Order by DINOSAURS.PERIOD,
DINOSAURS.DINO_NAME;