logo
    Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
JKW  
#1 Posted : Friday, August 31, 2018 11:55:12 AM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 43

As I understand it - the Consolidate Chem Codes funtion allows you to redirect incoming chemistry to the appropriate Chemcode. 

However - what do you do with SQL Server version if a second Chemcode has been created accidently in the system for an Analyte? 

I want to delete the error record. Ive converted all the Chemistry incorrectly allocated to the right chemcode via a SQL UPDATE statement -- and then when I go to the ZRef_Chemistry_Lookup table to delete the duplicate chem record - i keep getting the message "A comment is required for deletion'  -with no way to actually add the said comment. 

At the moment - - i think im going to go into the table in SSMS, disable the triggers then delete the row that way. Seems a bit of a heavy handed way to do it though.. Is there a better solution? 

NickT  
#2 Posted : Friday, August 31, 2018 1:12:36 PM(UTC)
NickT
Rank: Advanced Member

Reputation:

Groups: Registered, Administrators
Posts: 40

Was thanked: 1 time(s) in 1 post(s)

Hi Justin,

Basically everything you have just done manually is automated if you do the consolidation via the web interface.  There should be no reason for you to run any SQL queries.

Have a look at the ChemCode section of the online manual here for a description of the ChemCode admin tools.

If you've updated to the latest version of ESdat Server, you can also compare your ChemCodes to our online reference system, import consolidations and rerun them if someone has accidentally re-added an incorrect ChemCode that has previously been consolidated.

Cheers,

Nick

JKW  
#3 Posted : Wednesday, September 19, 2018 5:15:09 PM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 43

Thanks Nick, 

I was assuming the consolidation tool might do that, but it wasnt clear if it was also purging the existing chemcode from the lookup table. 

I'll double check its behaviour once we upgrade the server end. 

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.