Re: SQL Error
Dale E. Reed Jr. ( (no email) )
Wed, 05 Mar 1997 14:26:51 -0800
Danny Calamaro wrote:
>
> I checked the region setting and changed the setting on the PC running SQL
> server. I've deleted the database and created a new one, but I still get
> the same error. The actual Emerald error is..
>
> 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('','Danny', 'Calamaro','GibNet Ltd', 'What ever','The
> Same', 'Gib','gi', 'Gib','12345', '','', '','MyTown',
> '05/03/97','05/03/97', '19/03/97',0, 1,'Annually', ' Invoice','',
> '05/03/97','05/03/97', '','', '','', '',0, '','05/03/97 20:08:44', 'sa',0,
> 0, 0, 1)
This is in Eurpean date format DD/MM/YY. What is the regional setting
for short date on the SQL Server? It should the dd/mm/yy for it work
correctly.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com