Re: Duplicity?

[alta <al...@al...>]

Roger...

If you are concerned that the possibility of creating two invoices 
with the same number is an integrity issue (or a potential for 
confusion), consider trying a UNIQUE constraint on the invoice number 
field.

However, I tried something similar to prevent duplicate customer 
records, and got an error.  If I understand Dieter's explanation, 
this is because the record is created with a null in the id field.  
So, my sggestion may not work for other tables, either.

... Reed

On Friday 28 December 2001 12:40, you wrote:
> Invoices are distinguished by an internal ID, not the invoice
> number or a combination of invoice number and name.
>
> So, yes, you can enter the same information again, however, the
> invoices are different.
>
>
> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =========== On a clear disk you can seek forever ===========
>
> On Fri, 28 Dec 2001, Roger Samour wrote:
> > Hi, I was entering a Vendor invoice, and just to test it I
> > entered another invoice with the same Invoice number and under
> > the same vendor and it allowed me to do that. Am I doing
> > something wrong? or does it allow duplicate invoice numbers under
> > the same vendor?
> >
> > Roger J. Samour

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...