-back to www.ohio4h.org-

-back to database site-

SQL Statements

Resetting Member Participation Codes

UPDATE "Youth2a.db"
Set OrgClub=true,
Overcamp=false,
Schenrich=false,
Indstudy=false,
Childcare=false,
Insvideo=false,
Specialint=false

Setting All Volunteers to be Direct Volunteers

UPDATE "Youth2a.db"
Set DirectVol=true,
InDirectVol=false,
MidManager=false
WHERE (Category = "P" or
Category = "G" or
Category = "A" or
Category = "R")

Setting All Youth Leaders to be Direct Volunteers

UPDATE "Youth2a.db"
Set DirectVol=true
WHERE JrLead="true"

Setting the Grade for Volunteers to "-1"

UPDATE "Youth2a.db"
SET Grade = -1
WHERE (Category = "P" or
Category = "G" or
Category = "A" or
Category = "R")

Delete Old Club Links

DELETE FROM "Youth2xl.db" d
WHERE NOT (d.ClubID in (SELECT DISTINCT d2.ClubID
FROM "Youth2x.db" d2))

Delete Old Parent Links
(You need to run both of these separately)

DELETE FROM "Youth2bl.db" d
WHERE NOT (d.MemberID in (SELECT DISTINCT d2.MemberID
FROM "Youth2a.db" d2))

DELETE FROM "Youth2b.db" d
WHERE NOT (d.ParentID in (SELECT DISTINCT d2.ParentID
FROM "Youth2bl.db" d2))

Setting Projects to Completed

UPDATE "Youth2d.db"
SET Completed = true

Resetting Projects to Active Status

UPDATE "Youth2d.db"
SET "Youth2d.db"."Active"=true

If you have questions or comments, please direct them to:

 Todd Fox
4-H Youth Development
fox.185@osu.edu
614-292-9976