Solved

database format

Posted on 2002-06-24
7
213 Views
Last Modified: 2013-11-20
I have a program that needs to access a table of values. I would like to store this table in an external database. What format should I use. The table consists of about 130 rows x 3 columns. Each entry is a string that can contain ('+'/'-' and alph-numerics). I do not want this file to be easily read by users (ie I don't want it to be able to be read with a simple text editor). I don't mind if the file can be read by Access or a similar program. Any suggestions would be much appreciated. Please inform me reasons for your suggestions. I am currently programming in VS 6 enterprise.
0
Comment
Question by:skibud2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 

Expert Comment

by:vk1981
ID: 7104324
I use MySql. It's very cool...
0
 

Author Comment

by:skibud2
ID: 7104435
MySql is not quite what I am looking for. I use MySql with my php apps and it is very nice. It is not something that I would ship to customers. I was debating about using an access database or dbase file and using the CDaoDatabase class.
0
 
LVL 12

Expert Comment

by:migel
ID: 7104979
Hi!
You can use ADO objects to maintain database
this solution require install extra components: ms_dactyp.exe - MS Data Access Components to the user machine.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Expert Comment

by:christophm
ID: 7105690
For that small amount of data you can put it handily in a Microsoft Document (Document Architecture).  

- your users won't need a database
- not easily read/used by other applications
- easy to implement

~ create a row class that has three variables (CString) for each column

~ put all the rows in a CObArray

~ write the serialization routine(s)

good luck - christophm
0
 

Author Comment

by:skibud2
ID: 7106491
christophm,

Do you mind providing a simple CObject derived class for the rows. For some reason, I cannot get the SerializeElements to work.
0
 
LVL 2

Expert Comment

by:christophm
ID: 7108003
Hi skibud2,
I am working on a long note for you.  But, in the meantime --  your classes must inherit from CObject to be serializable.  cm
0
 
LVL 2

Accepted Solution

by:
christophm earned 200 total points
ID: 7108244
Hi skibud2,
Go to my web page  www.teleport.com/~millercg  and get the last download (bottom left).  The page is just a plain page the link is clearly labeled.  You will download a ZIP file that contains a Word95 document.  The document has the explanation and instructions from 'A' to 'Z'.  If you cannot get to that web page then send me your address (millercg@teleport.com) and I will EMAIL the ZIP file to you.
Good Luck - chris-m
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Different colored text in ComboBox without Subclassing 8 73
Detect CR LF to each line 12 175
substring method in java 1 136
c++  placing data into a form and an editbox 5 24
Introduction: Finishing the grid – keyboard support for arrow keys to manoeuvre, entering the numbers.  The PreTranslateMessage function is to be used to intercept and respond to keyboard events. Continuing from the fourth article about sudoku. …
Introduction: Dialogs (2) modeless dialog and a worker thread.  Handling data shared between threads.  Recursive functions. Continuing from the tenth article about sudoku.   Last article we worked with a modal dialog to help maintain informat…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question