RE: [Emerald] SQL Statement

Jason Powell ( (no email) )
Wed, 17 Feb 1999 15:16:07 -0800

But it would matter if I went:

Update MasterAccounts
Set BilledThru = PaidThru

This will copy the paid through date to the billed through date. This would
affect when an invoice was created....correct?

Thanks,

Jason

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

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