Josh Perry
Webmaster
NetConnect
http://www.netcnct.net/
joshp@netcnct.net
----------
> From: Mauricio Marquez <mmarquez@mail.eic.com.mx>
> To: emerald@emerald.iea.com
> Subject: Urgent help for Emerald newbie: Trying to add MBR
> Date: Wednesday, February 26, 1997 5:27 AM
>
>
> 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
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com