-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Friday, March 31, 2000 12:56 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] New Adjustment
"Robert H. Clugston" wrote:
>
> Dale,
> I removed this section:
> Select LastModifyDate, "Charge", Amount, Description, ChargeID
> From Charges
> Where CustomerID = @CustomerID
> and added your code:
> Select LastModifyDate, CASE When Amount < 0 then "Credit" ELSE "Charge"
> END, ABS(Amount) as Amount, Description, ChargeID
> From Charges
> Where CustomerID = @CustomerID
>
> Now I can't delete credit's or charge's. I'm running 2.5.329
You should still be able to delete the charges, but since it doesn't
know
what a credit is, you won't be able to delete a credit from the history
screen if you make that change.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart