Re: On columns with default ___ not null

In article <1993Jul26.131430.6640@pyra.co.uk> graeme@uk.pyramid.com (Graeme Sargent) writes: >In <CAMxuH.AyK@vcd.hp.com> kenm@vcd.hp.com (Ken Miles) writes: > > >>Why doesn't this work? > >>I create a table with a column spec something like the following: > >> part_number char(12) default " " not null, > >>The description from the SQL Reference manual suggests that the default >>will be put into the column on an insert if I don't specify anything >>but this is not always what happens. In an ISQL form I get the message >>"column .. does not allow nulls". > Try adding to the top of your form, in the database section the key words: WITHOUT NULL INPUT Bob -- --------------------------------------------------------------------------- |Bob Beaulieu Internet : bobb@netcom.com | |EZ TRAVEL Internet : eztravel@netcom.com | |4640-B Meridian Telephone: (408) 978-0808 | |San Jose, CA 95124 Facsimile: (408) 978-7024 | |+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++| | Serving all your travel needs from start to finish | | $$$ Best Fares $$$ | | Great Service | | Specializing in International Travel | ---------------------------------------------------------------------------