Re: [libreoffice-users] Re: Integer Not Null

SewHelpMe wrote:
> Let's see. First I'm using the design table and not SQL. (Haven't used since
> mid-1980's and don't feel I recall enough.)
>
> Next: I was altering an existing column, not adding it. So, the error
> message occurs as a popup when I try to save my changes.
>
> Interestingly enough, I did try adding another field with the same
> attributes and got a similar error.
>
> In the end, I deleted the entire table and recreated it from scratch.
>
> Given some of the odd things I've had happen, I suspect the SQL error is
> indicative of some bugs in Base.
>
> Thank you very much for the Guide. Since today is the first time I've used
> Base, I'm still also trying to figure out where things are located and how
> they work ... such as switching between a form's design and editing it (the
> button at the bottom doesn't seem to work).
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Integer-Not-Null-tp3990551p3990556.html
> Sent from the Users mailing list archive at Nabble.com.
http://wiki.documentfoundation.org/Documentation/Publications

     About 2/3 down the page lists a couple of Base Guide chapters that 
are available that should help to tell you where things are located in Base.
     When you edited the table using Design View, what did you select 
to change the field property to NOT NULL? Entry Required should be set 
to Yes to make the field NOT NULL.

--Dan

--
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