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