Toggle button .checked = true

barx · May 12, 2012

Hi

Can anybody explain this strange behaviour.

I am saving a record for a database I use

B4X:

Record.Put("sound", toggleSound.Checked)

When i paused on this line it shows that toggleSound.Checked = true

Yet when I read the field from database I get an error because the field = 1 Which cannot parse to true or false.

I know I can parse it myself but why does it show as true/false in ide on pause yet save in database as 1/0.

Database field is a BOOL btw

thanks

Mahares · May 12, 2012

If the database is SQLite, you can only store 1/0. It does not support Boolean class. See link below.
Results for: "boolean"

If I did not understand the question, please ignore my answer.

barx · May 12, 2012

Ah, I see. Never noticed that. Sure I have manually set true / false before and worked ok. Though I can't have if it doesn't support it. Lol

Guess its time for my int2bool lib to make an appearance.

Thanks for reply

Sent from my HTC Desire Z

barx · May 13, 2012

OK, done a little more investigating and found this...

if I wrap the true/false in ' ' it will save as true false. If I don't it saves as 0 / 1.

Does this mean that even though it type is set to Bool (in SQLManager) it is saving as text?

rbsoft · May 13, 2012

Does this mean that even though it type is set to Bool (in SQLManager) it is saving as text?

Yes.

See Sqlite documentation here:
Datatypes In SQLite Version 3

In order to maximize compatibility between SQLite and other database engines, SQLite supports the concept of "type affinity" on columns. The type affinity of a column is the recommended type for data stored in that column. The important idea here is that the type is recommended, not required. Any column can still store any type of data. It is just that some columns, given the choice, will prefer to use one storage class over another. The preferred storage class for a column is called its "affinity".

Rolf

barx · May 13, 2012

OK, I had this working and for some reason now it's not and I cannot get it right again.

I'm trying to save the state of a toggle button in a sqlite db and later read / update it also.

what would be the best way of doing this?

rbsoft · May 13, 2012

I personally save true/false in an Sqlite db as numerical value:
False = 0
True = 1 (or any nonzero value. Some languages also assign -1 to True).

B4X:

If value = 0 Then
  toggleSound.Checked = false
else
  toggleSound.Checked = true
End if

Rolf

barx · May 13, 2012

Ok going to try that, see if things settle down.

warwound · May 14, 2012

A bit of related info here: http://www.b4x.com/forum/basic4andr...eating-sqlite-db-outside-b4a-2.html#post81377.

And a solution here: http://www.b4x.com/forum/basic4andr.../14356-boolean-question-sqlite.html#post81351.

Martin.

Toggle button .checked = true

barx

Well-Known Member

Mahares

Expert

barx

Well-Known Member

barx

Well-Known Member

rbsoft

Active Member

barx

Well-Known Member

rbsoft

Active Member

barx

Well-Known Member

warwound

Expert

Toggle button .checked = true

Well-Known Member

Expert

Well-Known Member

Well-Known Member

Active Member

Well-Known Member

Active Member

Well-Known Member

Expert

Privacy & Transparency

Privacy & Transparency