Re: [Emerald] Error adding MBR

Dale E. Reed Jr. ( (no email) )
Mon, 03 Jan 2000 22:01:00 -0800

Humberto Guzman wrote:
> Hello,
> I upgraded to emerald 2.5 this past weekend, installing a new server with
> this version and leaving the old server as backup...
> But I get the following error when trying to add a MBR:
> INSERT MasterAccounts(ReferredBy, FirstName, LastName, Company, Address1,
> Address2, City, State, Zip, PhoneHome, PhoneWork, PhoneFax, SalesPerson,
> Region, CreateDate, StartDate, maExpireDate, Extension, Active, PayPerios,
> PayMethod, PayInfo, PaidThru, Last Received, PONumber, PrePaid,
> CreditCardNumber, CreditCardExpire, CreditCardAuth, CreditCardAuthBill,
> Comments, LastModifyDate, LastModifyUser, Balance, OverDue, SendMethod,
> GroupID, OverLimit, Taxable, BillingCycleID, BilledThru)
> VALUES('','test','test','','','','','','','','','','','Monterrey','000103','
> 000103','000201',0,1,'Anually','Invoice','','000103','000103','','','','',''
> ,0,'',GetDate(),'user',0.00,36,1,4,0,0,1,'000201')
> I already tried searching on IEA's website for an answer (such as the
> dateformat) without success...

Enable Debug mode in the Preferences, and see what the exact SQL
error is. Emerald 2.5 always uses ISO date format YYMMDD for dates,
so the above should be fine.


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

For more information about this list (including removal) go to: