From 9d2e2037edbba4dd5c78d92d5ced49ce76d17252 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 29 Oct 2014 17:10:43 -0400 Subject: [PATCH] KMAIN-269: Order records transfer to new bib record merge updated Cross-port: e8815e7 --- KCLS/sql/kmain-268/kmain-268.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/KCLS/sql/kmain-268/kmain-268.sql b/KCLS/sql/kmain-268/kmain-268.sql index a58459a7f9..44c0b63dcf 100644 --- a/KCLS/sql/kmain-268/kmain-268.sql +++ b/KCLS/sql/kmain-268/kmain-268.sql @@ -154,7 +154,7 @@ BEGIN FOR acq_lineitem IN SELECT * FROM acq.lineitem WHERE eg_bib_id = source_record LOOP -- ... and move them to the target record, updating marc as well UPDATE acq.lineitem - SET eg_bib_id = target_record, marc = target_mrc + SET eg_bib_id = target_record WHERE id = acq_lineitem.id; moved_objects := moved_objects + 1; -- 2.11.0