Re: Need some advice on project

new topic     » goto parent     » topic index » view thread      » older message » newer message

>From: Irv <irv at ELLIJAY.COM>
>
>....
>Hwy 52 at Fancy Gap? That sounds familiar. Where are you?
>....

The Appalachian mountains of southwestern Virginia.  (Thats right...I'm a
yellow-bellied, ridge-runnin', sap-suckin', gound-stompin', 'possum eatin'
heeelbilly blink

> > Here are some questions I have:
> >
> > What would be the best way to store the date?

>You could store it as a sequence {yyyy,mm,dd} and it would be easy to sort
>with custom_sort() as well as compare for less-than, equal, or
>greater-than.

I'll give it a try...

> > As you can see, the "Route" field is long compared to the others (and
>that
> > example is a short one).  There's a lot of repetition between records
>(i.e.,
> > I travel the same routes over and over again).  In order to make the
>field
> > more searchable, and to conserve space, I was thinking that it might be
>good
> > to let each route be represented by an integer.  The integer would be
>stored
> > in the file with all of the records, and a separate file would store a
>table
> > relating each integer with a specific route.
>
>A reasonable choice, especially if you might want to keep additional data
>about the routes (a map, perhaps, or terrain measurements)

I get the info for my routes off a county map.  I've already written a
(crude) program for displaying the map, which allows me to click on points
on the map to calculate the distance.  I'd eventually like to incorporate
that into this program.


All sounds pretty good.  I'll give it a try.

Ben

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu