Re: [Emerald] SQL Statement

Dale E. Reed Jr. ( (no email) )
Wed, 17 Feb 1999 14:56:23 -0800

Jason Powell wrote:
>
> I need to make the paid through date equal to the billed through date under
> master accounts. Because they are not the same, it is not creating
> invoices.
>
> Here is the question - I wanted to make sure this statement was ok to use
> before I mess it all up.
>
> Update MasterAccounts
> Set PaidThru = BilledThru
>
> Is this right???? I'm far from a SQL newbie :)

That is correct. However, Emerald doesn't use the PaidThru
date for any billing or calculations, so I don't see it
changing anything.

-- 

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