Database manipulation

LiveCode is the premier environment for creating multi-platform solutions for all major operating systems - Windows, Mac OS X, Linux, the Web, Server environments and Mobile platforms. Brand new to LiveCode? Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
jazzman809
Posts: 1
Joined: Sat Mar 20, 2010 3:16 pm

Database manipulation

Post by jazzman809 » Sat Mar 20, 2010 4:24 pm

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

ale870
Posts: 250
Joined: Tue Apr 22, 2008 9:17 am
Contact:

Re: Database manipulation

Post by ale870 » Tue Apr 06, 2010 1:03 pm

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?
Runtime Revolution Widgets, tutorials, tips & tricks and more!
http://runrevwidgets.com/wiki

Post Reply