search

coleifer / sqlite-web

Web-based SQLite database browser written in Python
MIT License
3.43k stars 339 forks source link

Value is not a numeric/real. for allow null #124

Closed rikhtehgaran closed 1 year ago

rikhtehgaran commented 1 year ago

Hi, I faced another problem when I wanted to add a new record it returned an error. while I set it to allow null for these columns, while I can add records from another client. these columns fill up later by my software and I need only to fill one column. what is this? image

coleifer commented 1 year ago

You need to put either the text "NULL" or an actual number, I suppose. But as it is, you are just storing the empty string ('').

rikhtehgaran commented 1 year ago

I set default null as you can see: image And get error again: image

rikhtehgaran commented 1 year ago

Also, i choose the numeric value default but get error too. it's very buggy image Error: image