Hi All In tailoring a new ctakes dictionary and trying to keep the changes as compact and easy to manage as possible, I'm clumping all modifications together at the end of the script file. This would include both additions and deletions.
Inserting into CUI_TERMS is no problem, but I have at least one instance where I'd like to delete from CUI_TERMS, rather than deleting the INSERT statement that put the term synonym into the script file in the first place. However, I haven't found an SQL DELETE statement that hsqldb likes. Here are some examples I tried DELETE FROM CUI_TERMS WHERE CUI=1414063 AND TEXT='lad' DELETE FROM CUI_TERMS WHERE CUI=1414063 AS NUMBER AND TEXT='lad' DELETE FROM CUI_TERMS WHERE CUI=1414063 AS BIGINT AND TEXT='lad' DELETE FROM CUI_TERMS WHERE CUI='1414063' AS NUMBER AND TEXT='lad' In all cases the script reader is treating the CUI value as a string and complaining that it can't cast it to an Integer/Number etc, which is why I also tried explicit casting, but that didn't work either. >>> error in script file line: 1850042 java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer >>> Has anyone successfully put DELETE statements in the script file? Regards Peter
