Re: [Emerald] Error adding MBR

Humberto Guzman ( (no email) )
Mon, 3 Jan 2000 20:13:01 -0600

I fogot to mention... When runinng this script in ISQL/w I get the
following:

Msg 233, Level 16, State 2
The column maCurrent in table MasterAccounts may not be null.
Msg 233, Level 16, State 2
The column maNew in table MasterAccounts may not be null.

Thanks !

HG

----- Original Message -----
From: Humberto Guzman <emerald@sysop.com.mx>
To: <emerald@iea-software.com>
Sent: Monday, January 03, 2000 8:07 PM
Subject: [Emerald] Error adding MBR

| 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...
|
| Thanks!
| Humberto Guzman
|
|
|
|
|
|
|
|
|
| For more information about this list (including removal) go to:
| http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart