Dan Lewis wrote > > Seems like I guessed wrong twice. The problem that you have has > to do with adding a field that is NOT NULL. When you add a field to a > table, it has no values until entries are made. So, selecting "Yes" for > Entry Required causes the error. > Create the field with "NO" selected for "Entry Required." Enter > the appropriate data making sure all the rows of the table have an entry > for it. Now edit the table by setting "Entry Required" to Yes. > > Good catch. There is also an option to turn off referencial integrity temporarily. http://hsqldb.org/doc/1.8/guide/ch09.html#set_refint-section (read warning, handle with care)
-- View this message in context: http://nabble.documentfoundation.org/Integer-Not-Null-tp3990551p3990898.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
