#5 Insert broken with "NOT NULL"

v1.0 (example)
closed-invalid
nobody
None
5
2010-11-13
2004-10-04
Anonymous
No

Actually, I have narrowed it down. The sqlitebrowser
will not add new record if any of the fields in a table
are created with the "NOT NULL" constraint. If the Add
Record button is selected, the error message "Please
select a table first."

jo3@brats.com

Discussion

    • status: open --> open-postponed
     
  • Logged In: YES
    user_id=114777

    Yes, you are right. The problem is that the browser creates
    a new empty record by default with NULL values in all
    fields, and the user then has the chance to populate the data.
    One ugly workaround for this would be to create this empty
    record with empty strings instead of NULL values in all
    fields, but it is not a solution I personally like. I don't
    have a definitive solution for this problem at this time:
    the browser has some features that were designed for
    beginners, and the create table options for example do not
    include the NOT NULL clause pre-listed. But we should at
    least attempt to trap this error and inform the user about
    what is happening in a clearer way. Marking as pending.

     
    • labels: 556733 -->
    • status: open-postponed --> closed-invalid