Re: [Emerald] SQL Command

Howard A. Brooks ( (no email) )
Mon, 14 Feb 2000 15:23:10 -0500

Thank you Jose...I appreciate this, my first SQL effort. After I
change all the dates I'll then plan to get each current account
balance (from NTPaymaster) and post a balance due with new dates
to hopefully produce our first Emerald invoices.

Howard A. Brooks, IamNet, Inc. - http://iamnow.net
"Your One Stop Internet Support and Solution Shop" -
howard@iamnow.net

> From: Howard A. Brooks <admin@iamnow.net>
> >Could someone please give me the SQL command to change all the
Paid Thru
> and Bill Thru dates to 01/31/2000, please?
>
> update masteraccounts
> set paidthru='1/31/2000', billedthru='1/31/2000'
>
>
> 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