OK, I'm having real difficulties getting some table creation Jet SQL code working.
The DEFAULT keyword doesn't seem to work. I was trying to using it in an ALTER TABLE statement, but some people here alerted me to the fact that there are problems adding fields to exisiting tables if you specify NOT NULL and a DEFAULT. But now I can't even use DEFAULT in CREATE TABLE. Which makes me suspect there's some other problem. (I was suspicious why NOT NULL DEFAULT wouldn't work with ALTER TABLE. I accept it might be slow if the new field is being put in a table with loads of rows, but all the documentation I have assured me that you *can* add a new field to an existing table with NULL disallowed and a DEFAULT value.) I was reading through the Jet SQL (for Access 2000) documentation, and noticed this: "Note: The DEFAULT statement can be executed only through the Jet OLE DB provider and ADO. It will return an error message if used through the Access SQL View user interface." Now, I'm not using the Access SQL View at all - I'm running <CFQUERY> statements via CF. But is there another issue here? ODBC driver updates? Anyone ever had problems with the DEFAULT keyword and Access 2000 DB's before? I even copied and pasted a CREATE TABLE statement with the DEFAULT keyword from the Jet SQL docs - it doesn't work unless I cut out the DEFAULT bit! Help! - Gyrus PS. I want the code I write to work with SQL Server as well, but I can only test on Access DB at the moment. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ______________________________________________________________________ Get Your Own 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=coldfusionb 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
