How do you change values after logging data to the citadel database (DSC)?

[Mattjk]

How would one go about changing values that already exist in the citadel database.  So say I were logging a numeric value with a timestamp for 1 year and then wanted to change a few values for the month of June because my sensor wasn't working at that time.  How could I do this?  Is it possible without re-creating the whole database over?

Thanks

Matt

[Ben]

DSC is supposed to be 21-CFR-11 compliant which techinally means it can be used in court as if it was a real physical log. So modifying a value in the DB ... is the equivelent of falsifying documents...

Don't think it can be done.

Ben

[Mattjk]

Hey Ben,

Thanks for the quick response.  I called NI and asked about this because this would be a big show stopper for me.  Their applications engineer said that the best way to change previous data would be to read in the trace that you want to change, modify it and save it as a new trace.  I am also looking into SQL querying.  I was able to connect to the citadel database by setting up a ODBC data source and using the database connectivity toolkit to query the database.  This worked.  Now I am trying to come up with a statement in SQL to change previously saved data.  I'll Keep you posted.

Thanks

Matt

[Ben]

---

@mattyk wrote:

Hey Ben,

Thanks for the quick response.  I called NI and asked about this because this would be a big show stopper for me.  Their applications engineer said that the best way to change previous data would be to read in the trace that you want to change, modify it and save it as a new trace.  I am also looking into SQL querying.  I was able to connect to the citadel database by setting up a ODBC data source and using the database connectivity toolkit to query the database.  This worked.  Now I am trying to come up with a statement in SQL to change previously saved data.  I'll Keep you posted.

Thanks

Matt

---

That reinforces my suspicions.

I have an app running for about 8 years now that keeps a paper trail to enusr ethe cartdiges used in respirators (operated NIOSH National Institute of Occupational Safety and Health par teh CDC) that use DSC to enusre nobody can ever falsify those records. If they can be hacked I my customer and anyone using a respirator with a NIOSH sticker on the side of it, want to know.

Ben