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

Josh Hillman ( (no email) )
Tue, 2 Mar 1999 09:56:20 -0500

From: Ed Miller <emiller@del.net>
>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?

You can add to the end of this, anything else that you may want to restrict
it with:

update invoices
set type = 'Void', lastmodifydate = getdate()
where date = '2/27/99'

Josh

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