LexBuild

Modify an Existing Record

Description:
  • Modify an existing lexical record from LEXICON.
  • User, Manager, Administrator

Logic Details:

StateDatabase tableSet LastActionDescriptions
Select
  • LEX_RECORD
  • LEX_RECORD_TEMP
  • INFL_VARS
  • INFL_VARS_TEMP
  •  Select an existing record through Close Match or LexAccess
    Modify  Modify record: category, Spelling Vars, etc..
    SubmitLEX_RECORD_TEMP check if the record with specified EUI is pending (exist in LEX_RECORD_TEMP)
    SubmitLEX_RECORD4 (Pending)update record with specified Eui
    SubmitLEX_RECORD_TEMP2 (modify)insert record into LEX_RECORD_TEMP
    SubmitINFL_VARS_TEMP Generate unique (var, infl, cat, cit, Eui, unInfl) inflVars and insert into INFL_VARS_TEMP
    ApproveLEX_RECORD_TEMP check if the record is Re-editing
    ApproveLEX_RECORD2update record in LEX_RECORD
    ApproveLEX_RECORD_TEMP delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 2
    ApproveINFL_VARS delete records from INFL_VARS with specified Eui
    ApproveINFL_VARS insert records to INFL_VARS from INFL_VARS_TEMP with specified Eui
    ApproveINFL_VARS_TEMP delete inflVars records from INFL_VARS_TEMP with specified Eui
    DenyLEX_RECORD_TEMP check if the record is Re-editing
    DenyLEX_RECORD2update record with Eui and lastAction = 4
    DenyLEX_RECORD_TEMP delete record in LEX_RECORD_TEMP with Eui and lastAction = 2
    DenyINFL_VARS_TEMP delete inflVars records from INFL_VARS_TEMP with specified Eui
    ViewLEX_RECORD_TEMP select all records in LEX_RECORD_TEMP with lastAction = 2