Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NULL - to NULL or not to NULL #3660

Open
DingBEN opened this issue Feb 2, 2020 · 1 comment
Open

NULL - to NULL or not to NULL #3660

DingBEN opened this issue Feb 2, 2020 · 1 comment

Comments

@DingBEN
Copy link

@DingBEN DingBEN commented Feb 2, 2020

Details

...have the need to have CELLs populate with a DEFAULT value (duh!)
VALUES in question: NULL, BLANK or '', any other value

  • able to set a CELL to BLANK or '' in Data TAB rows list
  • able to query a BLANK or '' CELL condition, rows return correctly
  • able to have query sweep CELLs and set them to BLANK or ''
  • NOT able to SET DEFAULT in STRUCTURE column config to BLANK or '', forced to NULL

Steps to reproduce - self evident

Operating system - WIN7 Pro

SQLiteStudio version - 3 .2.1

@tuffnatty

This comment has been minimized.

Copy link

@tuffnatty tuffnatty commented Feb 10, 2020

Works for me

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.