Urgent help for Emerald newbie: Trying to add MBR

Mauricio Marquez ( mmarquez@mail.eic.com.mx )
Wed, 26 Feb 1997 07:27:25 -0600

I installed 2075 but am having a problem adding my first MBR.

When I try to add a MBR (clicking on the save button), an error pops up:

SQL Error Adding Main Account

I clic on OK and this shows up:

INSERT MasterAccounts(ReferredBy, FirstName, LastName, Company, Address1,
Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax, SalesPerson,
Region, CreateDate, StartDate, maExpireDate, Extension, Active, PayPeriod,
PayMethod, PayInfo, PaidThru, LastReceived, PONumber, PrePaid,
CreditCardNumber, CreditCardExpire, CreditCardAuth, CreditCardAutoBill,
Comments, LastModifyDate, LastModifyUser, Balance, OverDue, SendMethod,
GroupID) VALUES('','Prueba', 'Apellido','', '','', '','', '','', '','',
'','Monterrey', '26/02/97','26/02/97', '12/03/97',0, 1,'Anual', '
Invoice','', '26/02/97','26/02/97', '','', '','', '',0, '','26/02/97 2:26:07
AM', 'sa',0, 0, 0, 1)

I read in the mailing list that the date format could be wrong, but I've
tried every possible format and it still doesn't work.

I need to do testing ASAP!

Thanks to all,

Mauricio