2 Replies - 718 Views - Last Post: 29 May 2012 - 08:31 AM Rate Topic: -----

#1 ninjatalon  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 16-January 11

Database, Serialization?

Posted 29 May 2012 - 07:20 AM

I have to come to a stop as I don't know which will be better in the near future.
I have a table that records many clients. Each client has several columns of info. Now what i'm wanting to do is on each client I need to have a list of errors that might have happen when I processed their info into the table. So I don't know if those list of errors i should have them in a different table or serialized in the same table.

the list of errors is dynamic, there's no way of knowing how many errors they might get.(this list of errors are inside a class, if i serialize the info)
For example:

-------Name---------Amount----------------Errors---
1. Joe D. 1000.26 'serialized'
2. Jane D. 1020.26
-
-
-
200. Bob D. 1104.26 'serialized'

------------------------------------------------------


or

-------Name---------Amount----------------Errors---
1. Joe D. 1000.26
2. Jane D. 1020.26
-
-
-
200. Bob D. 1104.26

------------------------------------------------------

Joe D's table.
-------Error---------Details---
1. A1 blah,blah,blah
2. B1 blah,blah,blah
-------------------------------

Bob D's table.
-------Error---------Details---
1. A1 blah,blah,blah
2. C1 blah,blah,blah
-------------------------------



So I don't know if this second method will work because if I have 200 clients with errors then i would have to create 200 tables of each clients errors, plus I have to do this every month. I'm worried it will become a mess with so many tables.

Is This A Good Question/Topic? 0
  • +

Replies To: Database, Serialization?

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9197
  • View blog
  • Posts: 34,551
  • Joined: 12-June 08

Re: Database, Serialization?

Posted 29 May 2012 - 08:13 AM

Are you asking about storing 'friendly' error messages for display to the user, or are you asking about recording errors as they happen?
Was This Post Helpful? 0
  • +
  • -

#3 ninjatalon  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 16-January 11

Re: Database, Serialization?

Posted 29 May 2012 - 08:31 AM

View Postmodi123_1, on 29 May 2012 - 08:13 AM, said:

Are you asking about storing 'friendly' error messages for display to the user, or are you asking about recording errors as they happen?


Yea just display errors regarding clients information, not the database itself. The Errors will be displayed on a Crystal Report.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1