Re: [Emerald] highest invoice #

Dale E. Reed Jr. ( (no email) )
Sat, 26 Jun 1999 17:53:11 -0700

Ben Conner wrote:
>
> Where is the highest invoice # kept in the Emerald DB? I had a crash a few
> days ago and had to roll back the DB to a known reliable copy, well before
> where I would like to have seen it. I just don't want to use the same
> invoice #s for new invoices, so I'd like to set it to a value I know is
> past the ones already issued but lost.

The Invoiecs table contains the identity value, which is want you are
looking for. What you have to do is:

-------------------
SET INDENTITY_INSERT Invoices On

Insert Into Invoices(InvoiceID, ...)
VALUES(xxx, ....)

SET INDENTITY_INSERT Invoices Off

Delete From Invoices Where InvoiceID = xxx
-------------------

You have to fill in the rest of the fields on the Invoices table. :)

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com