Page 1 of 1

Database manipulation

Posted: Sat Mar 20, 2010 4:24 pm
by jazzman809
Hi crew,

Here comes another confused newbie (ugh, the old dreaded newbie post, yuk :) Anyway my peeps, I'm trying to get my hands dirty with Rev Studio and have come up with a silly lotto game (is not even a real game).

For the moment I just want to be able to import a data file (.txt file) into a database table (we'll call it year I guess). The table would have 7 fields (excluding the ID, if needed). These fields would be the date and the lotto numbers (1 - 6). I may make number six the powerball but I haven't decided yet.

Then I just want to manipulate this data so I can enter a date somehwere and it should display the numbers for that date. I would also like to have the ability to display the whole file as well (like a report) elsewhere.

The process is really simple, at least in my head. I'm just trying to figure out what the best approach would be. I know that I have to somehow put the fields (date and fields 1 - 6) into an array of some kind

Any suggestions would be greatly appreciated. Also, if anyone has a sample of a lotto game or this type databasebase manipulation and would like to share it would certainly be welcome. No, I'm not trying to get rich, I just need a fun project to learn Rev with (I loose interested if it's not something I consider to be fun).

Thanks,

Jazzman

Re: Database manipulation

Posted: Tue Apr 06, 2010 1:03 pm
by ale870
hello,
how many data do you plan to store?
Do you want to re-create the complete history of lotto extractions?
How many records do you plan to maintain online?