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