RE: [Emerald] ONLine Setup

Ronnie D. Franklin ( ronnie@itexas.net )
Wed, 14 Apr 1999 22:34:21 -0500

It looks like the error is wherever the date is generated... as it is trying
to put a 0.00 in the dateadd function.....

> INSERT INTO MasterAccounts
> (FirstName,LastName,Company,Address1,Address2,City,State,Zip,Phone
Home,Phone
> Work,PhoneFax,
> Region,CreateDate,StartDate,maExpireDate,Extension,Active,PayPerio
> d,PayMetho
> d,LastReceived,
> PONumber,CreditCardNumber,CreditCardExpire,CreditCardAuth,Comments,
> LastModifyDate,LastModifyUser,maCurrent,maNew,GroupID) VALUES
> ('Don','Barron','','8 Quinvale Rd','', 'Hallett Cove','SA','5000','08 8387
> 3062','08 8231 0999','08 8212 8805',
> 'Adelaide',DEFAULT,DEFAULT,

dateadd(dd,0.00,getdate()),

DEFAULT,DEFAULT,
> 'Monthly','Invoice',DEFAULT,'', '','','', 'On-Line SignUp from
> [203.25.61.21]', DEFAULT,'signupsrv',DEFAULT,DEFAULT,4.00)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax
> near '0.00'.