Re: [Emerald] ONLine Setup

Dale E. Reed Jr. ( (no email) )
Wed, 14 Apr 1999 22:29:43 -0700

talon wrote:
> I was trying to setup this online server after making the changes Dale suggested. This is the error message i get when i submit the request to create the account.
> INSERT INTO MasterAccounts (active, firstname, lastname, address1,address2, city, state, zip, phonehome, phonework, phonefax, PayMethod, creditcardnumber, creditcardexpire, creditcardauth, GroupID, PayPeriod, Region, Extension, SalesPerson, LastModifyUser) VALUES(-1, 'Test','Test','test','','test','in','46222','317-244-1111',' ', ' ', 'Visa','4465612701212013','0301','T',1, 'Monthly','Indianapolis',10, 'Internet', 'Internet' )
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__MasterAcc__PayMe__7829DFE5'. The conflict occurred in database 'Emerald', table 'PayMethods', column 'PayMethod'
> /signup/signup.asp, line 1877
> I am new to ASP but I learn fast. Could anyone help me?? Please?? =)

I'm not familiar with the ASP script (I just downloaded it myself and
will take a look as I get time), but I do know what the SQL Error is.
This is a result of the Pay Method (in your case Visa) not matching one
of the PayMethods from the PayMethods table. It should be "Credit
not Visa. We consolidated all the CC paymethods into one for Emerald


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.