Skip to main content

Timeline for Storing quiz questions in SQLite

Current License: CC BY-SA 3.0

25 events
when toggle format what by license comment
Nov 6, 2016 at 11:51 comment added Schwesi @TimothyTruckle Thank you for that link! I will read it carefully!
Nov 6, 2016 at 11:46 comment added Timothy Truckle @Schwesi you should learn about the third normal form of a relational data model en.wikipedia.org/wiki/Third_normal_form (application design is complex... ;o))
Nov 6, 2016 at 11:41 comment added Schwesi @TimothyTruckle Thank you! That is a fantastic idea!
Nov 6, 2016 at 11:22 history edited Schwesi CC BY-SA 3.0
deleted 7249 characters in body
Nov 6, 2016 at 11:21 comment added Schwesi @t3chb0t thank you! I will comply with that in the future!
Nov 6, 2016 at 11:19 comment added Timothy Truckle @Schwesi BTW: "CREATE_TABLE_ACE ... + " TEXT, "+OPTA +" TEXT, " +OPTB + ..." You should consider to put the Options into a separate table referencing the corresponding Entry in the Question Table. This will allow you to easily change the number of possible answers and even allow different answer counts on different question types....
Nov 6, 2016 at 11:15 comment added Timothy Truckle @Schwesi "Thank you so so much for everything!!" as Dori sad: "Thats me: helping along..." ;o) But I did not help untill you understood my suggestions, so please ask what's confusing you.
Nov 6, 2016 at 11:15 comment added t3chb0t What should I do when someone answers my question? see number 2 about Posting a self-answer.
Nov 6, 2016 at 11:14 comment added t3chb0t You should post self-answer rather then editing the question if you want to show the updated code.
Nov 6, 2016 at 11:10 comment added Schwesi @TimothyTruckle Thank you so so much for everything!! I cannot put into words how much you helped me. Unfortunately, your code is very much out of my league. Therefore, I am just beginning to understand it bit by bit. I pasted the current state of my project, trying to implement your suggestions in the question.
Nov 6, 2016 at 11:08 history edited Schwesi CC BY-SA 3.0
added 7249 characters in body
Nov 6, 2016 at 10:56 answer added Timothy Truckle timeline score: 1
Nov 6, 2016 at 10:38 comment added Timothy Truckle @Schwesi BTW: why don't you get your questions collection parsed from the XML via JaxB?
Nov 6, 2016 at 10:35 comment added Timothy Truckle @Schwesi " I just get the string value from my strings.xml file" please add a sample of your resource XML file, 2 questions should be enough...
Nov 6, 2016 at 9:30 answer added Timothy Truckle timeline score: 1
Nov 6, 2016 at 7:04 vote accept Schwesi
Nov 5, 2016 at 19:07 answer added Timothy Truckle timeline score: 1
Nov 5, 2016 at 19:03 comment added Schwesi @Attilio Thank you so much! I tried something similar to that answer myself but without any luck. See updated question!
Nov 5, 2016 at 19:02 history edited Schwesi CC BY-SA 3.0
added my approach
Nov 5, 2016 at 18:53 comment added Attilio Maybe this answer on SO can help you? stackoverflow.com/a/10633657/3398271
Nov 5, 2016 at 18:47 history edited 200_success CC BY-SA 3.0
deleted 135 characters in body; edited tags; edited title
Nov 5, 2016 at 17:45 comment added Schwesi @downrep_nation I updated my question and added the Question Object. R is short for Resources, I just get the string value from my strings.xml file.
Nov 5, 2016 at 17:44 history edited Schwesi CC BY-SA 3.0
added question object
Nov 5, 2016 at 17:34 comment added downrep_nation can you add the Question object?, and what is R?
Nov 5, 2016 at 17:24 history asked Schwesi CC BY-SA 3.0