[RBASE-L] - Re: Custom colors in report BRUSH_COLOR

[J BLAUSTEIN]

I have removed the extra ")" - I'm trying to combine both table with all 
the information - but I need to allow for when no payments are made
J
On 4/8/2011 1:06 PM, jan johansen wrote:
J.
If I'm not mistaken you have a couple of ) that seem out of place (see 
below)
original
DROP VIEW VWA9iInvHIST
CREATE VIEW `VWA9iInvHIST` (INVNUM,INVDATE,SALE,TRANSDATE,PAYMENT) AS  +
SELECT INVNUM,INVDATE,SALE *)) * FROM VWINVTOT +
UNION SELECT INVNUM,NULL,0 FROM VWA9InvPmt WHERE INVNUM NOT IN (SELECT 
INVNUM FROM VWINVTOT)
RETURN
try this one
DROP VIEW VWA9iInvHIST
CREATE VIEW `VWA9iInvHIST` (INVNUM,INVDATE,SALE,TRANSDATE,PAYMENT) +
AS SELECT +
INVNUM,INVDATE,SALE +
FROM VWINVTOT +
UNION SELECT INVNUM,NULL,0 +
FROM VWA9InvPmt +
WHERE INVNUM NOT IN (SELECT INVNUM FROM VWINVTOT)
RETURN

Jan

    -----Original Message-----
    From: J BLAUSTEIN <jba...@pipeline.com>
    To: rbase-l@rbase.com (RBASE-L Mailing List)
    Date: Fri, 08 Apr 2011 12:54:28 -0400
    Subject: [RBASE-L] - Re: Custom colors in report BRUSH_COLOR

    I am trying to create a view from two other views
    view 1)  invnum,invdate,sale
    view 2) invnum,transdate,payment
    I would like a combine view with both the invoice total and payments
    I have used the below code and have an errror msg  invnum not a table


    DROP VIEW VWA9iInvHIST
    CREATE VIEW `VWA9iInvHIST` (INVNUM,INVDATE,SALE,TRANSDATE,PAYMENT)
    AS  +
    SELECT INVNUM,INVDATE,SALE )) FROM VWINVTOT +
    UNION SELECT INVNUM,NULL,0 FROM VWA9InvPmt WHERE INVNUM NOT IN
    (SELECT INVNUM FROM VWINVTOT)
    RETURN

    thanks for your help


    -- 
    *J. Blaustein *
    * J Blaustein Associates, Inc. *
    * 12 Herrick Drive *
    * Lawrence, NY 11559*
    * 516-371-3445 FAX 516-345-8009*



--

*J. Blaustein*

*J Blaustein Associates, Inc.*

* 12 Herrick Drive*

* Lawrence, NY 11559*

*516-371-3445 FAX 516-345-8009*