NeoDBpro boolean
Quote from lolo on July 5, 2022, 8:38 amКак правильно записывать ( Boolean ) в базу данных?
1 или True
У меня почему-то при любом варианте в БД записывается -1
Может кто проверит, не могу понять эта проблема в компоненте или у меня в программе?What is the correct way to write ( Boolean ) to the database?
1 or True
For some reason, for any option, -1 is written to the database
Can someone check if I can't understand this problem in the component or in my program?
Как правильно записывать ( Boolean ) в базу данных?
1 или True
У меня почему-то при любом варианте в БД записывается -1
Может кто проверит, не могу понять эта проблема в компоненте или у меня в программе?
What is the correct way to write ( Boolean ) to the database?
1 or True
For some reason, for any option, -1 is written to the database
Can someone check if I can't understand this problem in the component or in my program?
Quote from Vadim on July 5, 2022, 6:12 pm@lolo
When creating a table, you can specify the type of field.
https://neodbprohelp.visualneo.com/Tables.html#dbpCreateTable
When creating a table, you can specify the type of field.
https://neodbprohelp.visualneo.com/Tables.html#dbpCreateTable
Quote from lolo on July 8, 2022, 5:00 pm@vadim
да, так уже делал, но у меня по чему-то в БД пишется (-1,0)
переделал на обычный (int), пускай будет (1,0)yes, I already did that, but for some reason I write in the database (-1.0)
changed to normal (int), let it be (1.0)
@vadim
да, так уже делал, но у меня по чему-то в БД пишется (-1,0)
переделал на обычный (int), пускай будет (1,0)
yes, I already did that, but for some reason I write in the database (-1.0)
changed to normal (int), let it be (1.0)
Quote from Gaev on July 9, 2022, 2:51 am@lolo
According to this page ... https://www.w3schools.com/sql/sql_datatypes.asp
BOOL Zero is considered as false, nonzero values are considered as true.
BOOLEAN Equal to BOOLIf zero (0) and one (1) ... no trailing decimal points ... do not work as False and True, I suggest you just use a text (String) field and store text like isFalse and isTrue ... makes life a lot less frustrating ... with today's costs for memory and disk storage, the extra bytes per field is not going to cost anything meaningful.
According to this page ... https://www.w3schools.com/sql/sql_datatypes.asp
BOOL Zero is considered as false, nonzero values are considered as true.
BOOLEAN Equal to BOOL
If zero (0) and one (1) ... no trailing decimal points ... do not work as False and True, I suggest you just use a text (String) field and store text like isFalse and isTrue ... makes life a lot less frustrating ... with today's costs for memory and disk storage, the extra bytes per field is not going to cost anything meaningful.
Quote from rasl on July 10, 2022, 6:08 pmFor the database to react with 0=False and 1=True, the field must be Bit (the display in the neo tables is a check)
For the database to react with 0=False and 1=True, the field must be Bit (the display in the neo tables is a check)