Re: [Emerald] What version of Emerald should we be using?

Ed Miller ( (no email) )
Tue, 2 Mar 1999 07:35:00 -0500

We have over 150 Invoices to void. Does anyone have a SQL statement that
will void all invoices that were made on a given date?

Thanks
Ed

>Bernard Andrys wrote:
>>
>> What version of Emerald should we be using?
>>
>> It looks like some of our credit card accounts have been switched from
>> Credit Card to Renewal. But none of the clients are running 2.5.261
which
>> is (I think) the only version that had this bug.
>>
>> Does someone have a query that can fix the damage done by this bug?
>
>This should do it:
>
>Update MasterAccounts
>Set PayMethod = "Credit Card"
>Where CreditCardAutoBill = 1
> AND Datalength(CreditCardNumber) >= 13
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html