OOTP Developments Forums - View Single Post

Nukester · 06-12-2007, 08:45 PM

I have created a little app in Visual Foxpro that will create random debut files in 2 clicks. Yeah I could do it in one, but I split up the random debut generator and the export into two different parts. Anyway, its kind of crude right now, as I have some hard coded paths and havnt included an open dialog box yet so you can choose a database (I current have to copy the .csv files into a folder, but Id like to add in an open dialog), but its workable, and the whole routine takes about 20 seconds to finish.

My question had more to do with how you use, or would like to use, random databases. The way it is now, I have the program modify .csv files that are in a certain directory, and have the year range hard coded from 1900-2006. Im going to change it so that the user can choose the range in years. However, Im using the original Lahman DB as my data, and in 1903, with the historical modifications on, Im still getting guys blasting a ton of HR's, and guys from the 1800's stealing a ton of bases. Lance Berkman and Kent Hrbek tied for teh HR title in 1903 with 46 HR's.

Having never used a random debut database before this, are you better served using a normalized database, or should I just let it go with the original Lahman DB and see where it goes ?

06-12-2007, 08:45 PM	#1 (permalink)
Nukester All Star Starter Join Date: Dec 2001 Location: Newburgh, NY Posts: 1,903	Random Database Question for Utility I have created a little app in Visual Foxpro that will create random debut files in 2 clicks. Yeah I could do it in one, but I split up the random debut generator and the export into two different parts. Anyway, its kind of crude right now, as I have some hard coded paths and havnt included an open dialog box yet so you can choose a database (I current have to copy the .csv files into a folder, but Id like to add in an open dialog), but its workable, and the whole routine takes about 20 seconds to finish. My question had more to do with how you use, or would like to use, random databases. The way it is now, I have the program modify .csv files that are in a certain directory, and have the year range hard coded from 1900-2006. Im going to change it so that the user can choose the range in years. However, Im using the original Lahman DB as my data, and in 1903, with the historical modifications on, Im still getting guys blasting a ton of HR's, and guys from the 1800's stealing a ton of bases. Lance Berkman and Kent Hrbek tied for teh HR title in 1903 with 46 HR's. Having never used a random debut database before this, are you better served using a normalized database, or should I just let it go with the original Lahman DB and see where it goes ? __________________ Well, I don't really think that the end can be assessed as of itself as being the end because what does the end feel like? It's like saying when you try to extrapolate the end of the universe, you say, if the universe is indeed infinite, then how - what does that mean? How far is all the way, and then if it stops, what's stopping it, and what's behind what's stopping it? So, what's the end, you know, is my question to you. Last edited by Nukester : 06-12-2007 at 08:46 PM.