Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    invalid identifier" doing SQL update; incorrect result for z304_rec_key


    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care


    Problem Symptoms:
    1) update patron records via SQL results in error "invalid identifier"  

    2) incorrect result for z304_rec_key 



    An SQL Update statement can not reference other libraries in a Where clause. It can reference other libraries only via an "in" clause. 



    Analysis and Solution is in an Internal Note; contact Ex Libris Support.



    • Article last edited: 12-Mar-2016
    • Was this article helpful?