Skip to main content
ExLibris
  • 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 

     

    Cause:

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

     

    Resolution:

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

     

     


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