Re: Creating Invoice Problem

Dale E. Reed Jr. ( (no email) )
Sat, 31 May 1997 11:35:52 -0700

Kelly Wright wrote:
>
> Attached are the results.
>
> >
> > try a:
> >
> > DBCC CheckDB(Emerald)
> >
> > on the Emerald database from isql_w. You could have an identity problem
> > in the database.

This did correct one table, but actually I gave you the wrong command.
Sorry.
Part of Emerald 2.2 is a new Database Consistency script. I just put
the
script up in /emerald/beta on the ftp site. Its called CheckDB.sql.
Run this script (your Database MUST be called Emerald for it to work)
and send me the results. I am mainly looking to see if it correct
an identity problem for your InvoiceItems table.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com