[libreoffice-users] Re: Integer Not Null

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: users+help@global.libreoffice.org
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