Comments (8)
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.
from sqlitebrowser.
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.
from sqlitebrowser.
This was a bug in the parser grammar, thanks!
should be working with f3a2a74
from sqlitebrowser.
@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)
from sqlitebrowser.
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.
from sqlitebrowser.
@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:
I haven't personally tested it, but I'm 80% sure. 😄
from sqlitebrowser.
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.
from sqlitebrowser.
Cool. 😄
from sqlitebrowser.
Related Issues (20)
- [Bug]: creation of new db file upon attach of non-existing file fails. HOT 2
- [Feature]: "Filter in any column" should only filter in '__rowid__' is visible HOT 3
- Add Debug Information to 'Continuous' Release HOT 2
- Check Update for Unstable Build HOT 1
- Port to Qt 6 HOT 1
- Rewrite Build Entries in the Wiki HOT 1
- Support for Branch-Specific Build Variants HOT 1
- [Bug]: Importing CSV with column headers doesn't work if columns are not in same order as table in DB HOT 1
- Quick Browse HOT 1
- [Feature]: Comment Line Shortcut key for "Execute SQL" tab and Shortcut Key selection screen HOT 3
- [Feature]: auto reopen last database HOT 7
- No data returned from SQL query HOT 2
- [Bug]: Can't run nightly build on macOS 12.7.4 HOT 7
- [Bug]: External drives cannot be opened on Ubuntu HOT 3
- [Bug]: Execute SQL Console overlaps text HOT 2
- [Feature]: Allow NOT operator '!' in front of filters
- [Bug]: Find and Replace fails to replace all finds HOT 1
- [Bug]: Copy/paste results of SQL select hangs / freeze program
- [Feature]: Plot - change axis to log scale
- [Bug]: When you start the program, an error message appears. HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlitebrowser.