[RBG7-L] - Re: UNION command

[Brad Davidson]

Thanks, David for the tip – I’ll give it a go.   -Brad Davidson   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: Tuesday, October 11, 2005 8:33 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: UNION command   Brad   Instead of the OLD Union command, use the UNION feature of SELECT to create a temporary view, or project a table from that view.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Brad Davidson To: RBG7-L Mailing List Sent: Tuesday, October 11, 2005 9:49 AM Subject: [RBG7-L] - Re: UNION command   Brad, it's not clear exactly what you did.  Please send the code so we look it over!   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261   Thanks for looking at this. A correction: two permanent tables in UNION to form a temporary table (at least my intent).   Commented code a work around which is in production working without incident. But, again, want to understand why I receive error message… StaticDB and Multi are set to on in our environ.   Thanks again, Brad Davidson   ---------------- DROP temp_presocancel UNION soline WITH sohdr FORMING temp_presocancel   --CREATE TEMPORARY VIEW temp_presocancel + --(so,detailnum,custid,sodate,shipdate,creditmemo,pn,qty,condition, + --sellprice,discountp,saleprice,extprice,sonote,ostat) AS SELECT     + --so,detailnum,custid,sodate,shipdate,creditmemo,pn,qty,condition,    + --sellprice,discountp,saleprice,extprice,sonote,ostat     FROM         + --sohdr t1, soline t2 WHERE t1.so = t2.so AND t1.so = .vso   DROP temp_socancel PROJECT TEMPORARY temp_socancel FROM temp_PREsocancel USING * WHERE so = .vso   ALTER TABLE temp_socancel ADD COLUMN qtyret INTEGER ALTER TABLE temp_socancel ADD COLUMN OffSet=(qtyret*-sellprice) CURRENCY     EDIT USING SOCANCEL WHERE so = .vso