rookie needs experienced advice

Index

2011-05-30 13:49 – Gary Jeurink : rookie needs experienced advice

2011-05-30 15:13 – Fred Taylor : Re: rookie needs experienced advice

Author: Gary Jeurink

Posted: 2011-05-30 13:49:50 Link

I'm building a gymnastics scoring system from scratch. I'm pretty set on the

main structure but I need some how to advice. The athletes will be entered

and sorted first by Div. then Age Group and last by Team. Scores & Places

will be in each athlete record. Here is where I get hazy. A competitive

Session could be Level 1's - 10-12 yr old and Level 2's all ages. Then at

completion of a Session [could have 10 or 12 sessions per meet] I need

individual results and possibly a Team score which could be accumulative

from another session.

In my old pascal version, I built a session table and turned on or off each

[level-age group] for that session and another table to designate which

[level-age groups] make up a particular team scores. Then at conclusion of a

session I run awards&places for that session and append 0 to 2 team scores

if needed for that session. (I need to filter out teams too cheap to enter

team competition also per level). My old dos based program works great as

long as I am there to request the correct results per session but the

database was static and we out grew it. I even PDF results to internet

website within 10 min. of conclusion.

How do I design a table that can predefine the proper result document per

session since they can potentially be so different? I'm not lazy but a bit

overwhelmed on a strategy. Thank you much, you guys have kept me creeping

forward for many years. I got the book Ted, thanks.

Gary Jeurink

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/6F1CC58687A5413A81D0CF72BBF0ADEC@OwnerPC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

New Search

Re: rookie needs experienced advice

Author: Fred Taylor

Posted: 2011-05-30 15:13:42 Link

Sounds like SQL SELECT queries could get what you need when you're ready to

do a "standings". You'd need a table of teams, a table of athletes (with

their teams/ages/levels) and a scores table with sessions/athletes. Then

you'd pull the data from these tables as needed, using WHERE conditions on

your SELECT statements to get the data you want.

Fred

On Mon, May 30, 2011 at 10:49 AM, Gary Jeurink <g.jeurink@charter.net>wrote:

> I'm building a gymnastics scoring system from scratch. I'm pretty set on

> the

> main structure but I need some how to advice. The athletes will be entered

> and sorted first by Div. then Age Group and last by Team. Scores & Places

> will be in each athlete record. Here is where I get hazy. A competitive

> Session could be Level 1's - 10-12 yr old and Level 2's all ages. Then at

> completion of a Session [could have 10 or 12 sessions per meet] I need

> individual results and possibly a Team score which could be accumulative

> from another session.

> In my old pascal version, I built a session table and turned on or off each

> [level-age group] for that session and another table to designate which

> [level-age groups] make up a particular team scores. Then at conclusion of

> a

> session I run awards&places for that session and append 0 to 2 team scores

> if needed for that session. (I need to filter out teams too cheap to enter

> team competition also per level). My old dos based program works great as

> long as I am there to request the correct results per session but the

> database was static and we out grew it. I even PDF results to internet

> website within 10 min. of conclusion.

> How do I design a table that can predefine the proper result document per

> session since they can potentially be so different? I'm not lazy but a bit

> overwhelmed on a strategy. Thank you much, you guys have kept me creeping

> forward for many years. I got the book Ted, thanks.

> Gary Jeurink

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

[excessive quoting removed by server]