-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Tuesday, June 16, 1998 11:07 PM
Subject: Re: SQL Errors
>Richard Sensale wrote:
>>
>> Hi lately when adding users in Emerald. I have been getting errors like
the
>> following.. These are all SQL errors. adding MBRs.
>
>If you run the below SQL statement in ISQL_W against your Emerald
>database, what error do you get?
>
>> 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('','Denyaz', 'Farhat','', '15030 Colson','',
>> 'Dearborn','MI', '48126','(313) 582-3238', '','', '','Dearborn',
>> '6/16/98','6/16/98', '6/30/98',0, 1,'6 Mons Spec', ' Invoice','',
>> '6/16/98','6/16/98', ' ','', '','', '',0, '','6/16/98 1:34:15 PM',
'sa',0,
>> 0, 0, 1)
>
>I don't see any issues from the statement. YOu might want to run the
>checkdb.sql script to see if it reports an ident problem on your
>MasterAccounts table.
>
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com