Re: [Emerald] ONLine Setup

Dale E. Reed Jr. ( (no email) )
Thu, 15 Apr 1999 13:20:47 -0700

talon wrote:
> Ok.. i made the changes to "Credit Card" but now I get this error:
> 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, 'Tim2','Blanton','43 Test','','Indpls','in','46222','317-244-3849',' ', ' ', 'Credit Card','49963612701212013','0301','Tim Blanton',1, 'Annually','Indianapolis',10, 'Internet', 'Internet' )INSERT INTO SubAccounts (CustomerID, Login, Email, FirstName,LastName, PhoneHome, PhoneWork, AccountType, Discount, Description, Password, SystemType, ModemSpeed, NetSoftware, Operator, LastModifyUser, LoginLimit, saCurrent ) VALUES(1062,'test123','','Tim2','Blanton','317-244-3849',' ', '56K','Normal Users','32mb','Fo*083','pentium','33600','MS Explorer 3.0','Internet','Internet',2,-1)
> 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__SubAccoun__Accou__0A489020'. The conflict occurred in database 'Emerald', table 'AccountTypes', column 'AccountType'
> /signup/signup.asp, line 1947
> Any ideas?

Its the same type of Error. You need to modify the account list to
match YOURS. In the above the AccountType is 56K. Do yuo have a
service type of 56K?


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