From bf915098d722f39573e6ed7bc18cd612a5c4a761 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 7 Feb 2007 14:18:51 +0000 Subject: [PATCH] =?utf8?q?Bei=20UNIONs=20m=C3=BCssen=20immer=20die=20gleic?= =?utf8?q?hen=20Spaltenanzahlen=20herauskommen.=20Fix=20f=C3=BCr=20ein=20P?= =?utf8?q?roblem,=20das=20in=201309=20hinzukam;=20Bug=20537.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/IC.pm | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/SL/IC.pm b/SL/IC.pm index 11bf58690..0ccdf89a1 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -1145,7 +1145,7 @@ sub all_parts { p.priceupdate, p.image, p.drawing, p.microfiche, pg.partsgroup, '' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, - ct.name|; + ct.name, NULL AS deliverydate|; if ($form->{ordered}) { $query .= qq|$union @@ -1172,7 +1172,7 @@ sub all_parts { p.priceupdate, p.image, p.drawing, p.microfiche, pg.partsgroup, '' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, - ct.name|; + ct.name, NULL AS deliverydate|; $query .= qq|$union SELECT $flds, 'oe' AS module, 'purchase_order' AS type, @@ -1210,7 +1210,7 @@ sub all_parts { p.priceupdate, p.image, p.drawing, p.microfiche, pg.partsgroup, '' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, - ct.name|; + ct.name, NULL AS deliverydate|; if ($form->{quoted}) { $query .= qq|$union @@ -1237,7 +1237,7 @@ sub all_parts { p.priceupdate, p.image, p.drawing, p.microfiche, pg.partsgroup, '' AS invnumber, o.ordnumber, o.quonumber, oi.trans_id, - ct.name|; + ct.name, NULL AS deliverydate|; $query .= qq|$union SELECT $flds, 'oe' AS module, 'request_quotation' AS type, -- 2.20.1