Problem with default values when adding Record

[sqlitebrowser]

Problem with default values when adding Record

[rp-]

We(sqlite3) will use your DEFAULT values, the problem was more that we didn't sync the view with the real data, after inserting a new row.
Commit 6705e8c will fix the not synced view, and hopefully give a better view what was inserted by DEFAULT.

I don't think we have the same user experience for adding rows as SQLiteManager, so a preview of what would be inserted isn't really possible, after hitting the "insert row" button the insert statement was already executed and only a revert will undo your action.

[jzsoftware]

So it should indeed use default values? (Because I have a table, where the structure is like this:
The problem is that when I press insert, the data inserted does not use the Default value for the 'date' (datum) column.I reloaded the table to work around the sync issue you wrote about.

[rp-]

This was a bug in the parser grammar, thanks!
should be working with f3a2a74

[justinclift]

@jzsoftware Would you be ok to try the next automatic nightly build, to verify this is working for you?

http://rp.oldsch00l.com/sqlitebrowser/

(you'd need to wait until tomorrow, for the next build to be made)

[jzsoftware]

Is it possible that your nightly build is only for 32-bit Systems (because
the .exe file [after removing the .xz extension] does not work on my
Windows 7 64-bit System.

[justinclift]

@jzsoftware When you say you removed the .xz extension, did you do that by renaming it, or by decompressing it?

In theory, 7-zip should be able to decompress .xz files:

http://www.7-zip.org

I haven't personally tested it, but I'm 80% sure. 😄

[jzsoftware]

Ah, I figured it out (didn't know that .xz was a compression format, now I
do:) ).
And using default values does work with this version now.

[justinclift]

Cool. 😄