P.S I may be a little off due to the way SQL was handled after version 7 from MS. In version 7 you had to use the WITH clause and for 2000 it is without the WITH clause. Not real sure about access 2000.
There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 6:00 PM Subject: Re: ALTER TABLE syntax > Should be more like this shouldnt it? > > > ALTER TABLE test > ADD COLUMN testNum BYTE NOT NULL WITH DEFAULT 5 > > > > You need the WITH clause..... > > > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > ----- Original Message ----- > From: "Gyrus" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, January 09, 2002 5:28 PM > Subject: ALTER TABLE syntax > > > > Any idea what's wrong with this SQL? > > > > ALTER TABLE test > > ADD COLUMN testNum BYTE NOT NULL DEFAULT 5 > > > > This is using Access 2000. It seems to be the DEFAULT > > that's causing problems (works OK with just NOT NULL, > > or without constraints altogether). > > > > Even statements copy-pasted from the MS Jet SQL > > reference docs seem to not work with DEFAULT. Any > > common pitfalls with this clause? > > > > thanks, > > > > - Gyrus > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > - [EMAIL PROTECTED] > > work: http://www.tengai.co.uk > > play: http://www.norlonto.net > > - PGP key available > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
