1. nieko baarda
  2. Valentina Studio
  3. Четверг, Март 26 2020, 08:34 PM
  4.  Подписаться через email
In Data Editor all fields without values display <NULL> how can I configure the display so fields with <NULL> display as empty fields ?
Вложения
Комментарий
There are no comments made yet.
Pierce DuBrock Ответ принят
Edit the tables fields and turn off the nullable flag?. This what you are after?.
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
There is no such option for the Data Editor.

But as Pierce suggested you can use a Nullable flag.
Most probably SQLite will not allow you to change the Nullable flag when data is in the table.
So you can set it for a new table before adding/importing records to this table.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Nieko Baarda
Suggestions from (person) chat-bot Paradigma solved my question.
Fields where checked (v) for Nullable before import csv file.
Changed flag by uncheck Nullable. Than import csv file and empty fields show empty. Thanks for help.
Комментарий
There are no comments made yet.
nieko baarda Ответ принят
Thanks for help.

If flag of fields unchecked Nullable before import csv file, empty fields show empty.

I need to do this by first create fields that exist in the csv file.

The first row of my csv file contains the field names.

So I need, when not creating table and fields by myself, in the Import Wizard the option setting Nullable / NoNullable for fields of the csv file, if importing a table (fields and values).
See attachment:
valentina_import_table_auto_check_nullable.jpg

Do I something wrong when importing in the Import Wizard a table (fields and values) without first creating the table and the fields ?
Вложения
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories