Re: Need some advice on project
- Posted by Ben Logan <wbljr79 at HOTMAIL.COM> Oct 03, 1999
- 491 views
>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> > 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