In other words you can't set a default with SQL? That seems to be what I'm getting across the board. Damn MS people.
thanks, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com > -----Original Message----- > From: Jerry Barnes [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 22, 2003 9:39 AM > To: CF-Talk > Subject: RE: defaults in Access > > > http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html > > J > > -----Original Message----- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 6:27 PM > To: CF-Talk > Subject: defaults in Access > > > Anyone know how to add a default constraint to a field in MS > Access using only SQL? I've tried a bunch of variations on the > SQL Server syntax and none of them work. > > thanks, > barneyb > > --- > Barney Boisvert, Senior Development Engineer > AudienceCentral > [EMAIL PROTECTED] > voice : 360.756.8080 x12 > fax : 360.647.5351 > > www.audiencecentral.com > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
