From: "Jeffrey M Donley" <jeffd@lmf.net> Subject: RE: [Emerald] Signup Date: Sat, 2 Nov 2002 05:51:02 -0500 Message-ID: <DDEDJOHLDAIGFOJIBADAGEBACPAA.jeffd@lmf.net>
Thank You Doug, That was the problem.
Jeff
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Doug Harpster
Sent: Friday, November 01, 2002 12:46 PM
To: emerald@iea-software.com
Subject: RE: [Emerald] Signup
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
>
>
------------
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