Meaningless Drivel is fun!*
The moose likes Android and the fly likes Lists inside SQLite Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Mobile » Android
Bookmark "Lists inside SQLite" Watch "Lists inside SQLite" New topic
Author

Lists inside SQLite

Sunny Rodriguez
Greenhorn

Joined: Jun 30, 2009
Posts: 5
Hi,

I am creating an application that allows you to log the days you do a particular exercise. I am using SQLite to store each Exercise in a table that has attributes such as Sets, Reps, Weight. What I am confused about is how to store the dates. I want to store the dates so that when you click View Summary of an Exercise, you will see a list of all the days that you did the exercise and how many sets, reps, and weight. To store the dates I figured I would have to add a new column to the table using ALTER command and make the date the name of the column but then that would be inefficient.

I thought about storing objects, tables, and arrays inside of SQLite but I haven't seen any finite examples, if that. I thought about storing all the attributes inside of a custom Exercise object that would then be store in internal memory but I like the idea of a database to store the info.

What is the best way to store the dates?

Thanks

Edit:
After doing some research I realized I could create a new table and just make a column that stores an ID of the exercise and then another column that has the dates. Then I could just perform a SELECT to get only certain exercise.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Lists inside SQLite
 
Similar Threads
Parsing a date and retaining the format
Trouble writing to bean
Exercise
Deliver Test data with App
Calendar Program