[RBG7-L] - Re: UNION command

[Brad Davidson]

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