[Emerald] SQL Server Error... adding service

David Routh ( drouth@davlin.net )
Wed, 31 May 2000 10:35:48 -0500


I went to add another service to an existing MBR and when I saved it and it
asked if I wanted to create an Invoice I said yes.... that's when I got
this error:

SQL Server Error: 547 INSERT statement conflicted with COLUMN FOREIGN KEY
constraint 'FK_Invoicelt_TaxID_2CBDA3B5'. The conflict occurred in database
'Emerald', table 'Taxes', column 'TaxID'.
State=1, Severity=16

After clicking past the error I got this:

SQL Error2 Adding Invoice Item

Then this message:

Rolling back last invoice

What's all this telling me... needless to say it didn't create the Invoice.

Using Emerald 2.5.334

Thanks, David

For more information about this list (including removal) go to: