• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Storing Array of String in MS-Access

 
ishan dave
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,

this is my code, I am facing problame to store the String array in Microsoft Access database so some one please guide me that how can I store the same.

thank you

ishaan


 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 65335
97
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"ishan is here",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
JavaRanch Sheriff
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Storing a list (or array) in a single field is an example of database denormalisation, ie it is not something you usually want to do. If you gave each field a composite key made from the insert number and the order then you would be a step closer. eg insert (1, 1, 'one'), insert (1, 2, 'two') then insert (1, 3, 'three') and then retrieve by the first field, ordered by the second.

You could store the array as a serialised object, but I usually recommend against serialised objects in the DB.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic