RE: [Emerald] Signup

New Message Reply Date view Thread view Subject view Author view
Doug Harpster (dharpster@kans.com)
Fri, 1 Nov 2002 11:45:55 -0600



From: "Doug Harpster" <dharpster@kans.com>
Subject: RE: [Emerald] Signup
Date: Fri, 1 Nov 2002 11:45:55 -0600
Message-ID: <241FD0B346141047953B9D4AEDC8C044028FCC@mail.carrollsweb.net>

Jeff,

Do you still have an entry with a discountid of 1 in your discounts table? The only thing I can think of that would throw this error is if there was no discount with an id of 1.

Doug

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of
> Jeffrey M Donley
> Sent: Friday, November 01, 2002 11:02 AM
> To: emerald@iea-software.com
> Subject: [Emerald] Signup
>
>
> Hello List,
> I have a odd problem and am wondering if anyone has had this
> and resolved it. I customized the sign up zip for emerald 4
> and had it working, out of the blue it started throwing this error:
>
> INSERT INTO SubAccounts
> (CustomerID,Login,FirstName,LastName,PhoneHome,PhoneWork,Accou
> ntTypeID,
> Password,MaidenName,SystemTypeID,ModemSpeedID,Operator,LastModifyUser,
> NetSoftwareID,PayPeriodID,DiscountID,BilledThru,DomainID)
> VALUES (12213,'superman','Super','Man','123-4532','',39,
> '1234x','test',9,4,'signup','signup', 7,1,1,getdate(),1)
> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT
> statement conflicted with COLUMN FOREIGN KEY constraint
> 'FK__SubAccoun__Disco__4336F4B9'. The conflict occurred in
> database 'Emerald4', table 'Discounts', column 'DiscountID'.
>
> Any suggestions
>
> Thanks
>
> Jeff
>
> ------------
>
> This is a user supported list. If you require assistance from
> IEA Software's Support Engineers, please check out our
> Support resources at http://www.iea-software.com/support.
>
> For more information about this list (including removal) go
> to: http://www.iea-software.com/support/maillists/liststart
>
>



New Message Reply Date view Thread view Subject view Author view
This archive was generated on Fri Nov 01 2002 - 09:26:41 Pacific Standard Time