From: "Jeffrey M Donley" <jeffd@lmf.net> Subject: [Emerald] Signup Date: Fri, 1 Nov 2002 12:02:26 -0500 Message-ID: <GAEHIKBCFLDAOHNDPKGCIEHGCPAA.jeffd@lmf.net>
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,AccountTypeID,
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