Jan, DISTINCT needs a column name after it.
Bill On Mon, Dec 7, 2009 at 12:39 PM, jan johansen <[email protected]>wrote: > Group, > > This morning as I was troubleshooting a process for generating invoices, I > ran into challenge > > I have a cursor that works fine and generated 39 invoices. The problem was > that my method > to determine how many invoices would print calculated 33 invoices. While a > minor issue, I > need a better to count. > > My cursor has the following; > * > DECLARE > + > DISTINCT WOBILLID , CustPO FROM Invoiceing + > WHERE Status = 'D' AND BillingType = 'G' * Invoice *CURSOR* *FOR* *SELECT > * > > My calculation has; > * > SELECT > (DISTINCT ) INTO vCountWOBILLID FROM Invoiceing + > WHERE Status = 'D' AND BillingType = 'G' * *COUNT* WOBILLID > I know, I know. They are different. However when I tried to change my > SELECT to > > > > SELECT *COUNT(DISTINCT ) INTO vCountWOBILLID FROM Invoiceing + > WHERE Status = 'D' AND BillingType = 'G' > * WOBILLID,CustPO > I get an error. > > My suspicion is that the aggregate COUNT doesn't like it. I just found it > interesting that I could declare a > distinct cursor on 2 columns but not count distinct on 2 columns. > > The reason for the distinct is that a customer could send several different > po's during a billing cycle > Also the possibility exists that 2 different customers could use the same > PO. > > Any suggestions are appreciated. > > Jan > > > > > -----Original Message----- > From: Lawrence Lustig <[email protected]> > To: [email protected] (RBASE-L Mailing List) > Date: Mon, 7 Dec 2009 09:22:30 -0800 (PST) > Subject: [RBASE-L] - Re: 7.6 Entry/Edit form > > << > I do not want the user to be able to add additional rows when in EDIT mode. > >> > > Try (in the AFTER START EEP): > > IF RBTI_FORM_MODE = 'EDIT' THEN > PROPERTY TABLE YourTableName 'DISABLE_ADD_NEW_ROWS' > ENDIF > > -- > Larry > > > > > >
