Page 1 of 1

PostPosted: Sat Jan 06, 2001 6:53 pm
by Velvis
I have an app which needs access to a database. The app will track up to 10 seperate people and each person will have "scores" in 8 categories.

#1) Data will not be recorded one person at a time. (ie Person 1, score 1, person 2, score 1, person 3, score one...)
Similar to how you would score a bowling game.

#2) It will not always be 10 people, thats just a maximum.

#3) I need to keep the data for each person individually.
(ie I dont want to save all the data together, but by person)
What is the best way to approach this?

Is Pocket C a good candidate for this?

Thanks for any suggestions

PostPosted: Sun Jan 07, 2001 3:14 pm
by tclarke
A very straight forward to do this would be to set up 80 records... First digit of record number is the number assigned to a person... the second digit is number assigned to which of 8 scores... Then do a dbrec((iPersonNumber * 10)+iScoreNumber) to get to the right record... dberase() to erase the current contents (or store it or whatever), then dbwrite(iScore) to update with the new score...