Powered by Jitbit .Net Forum free trial version. dismiss

HomeProblems and issues

Post bug reports here. The forum is pre-moderated, your message will appear after being checked by us.

Boolean column cannot be inserted or updated Messages in this topic - RSS

falloutphil
falloutphil
Posts: 29


8/3/2017
falloutphil
falloutphil
Posts: 29
Hi,

If I make a table editable, but it contains a boolean column, there is a problem that the boolean input is taken as a string:

42804: column "ultimate_mapping" is of type boolean but expression is of type character

I can get around this by writing triggers on insert and update that cast the string to a boolean - but this is a bit ugly and extra legwork.

An edit of a boolean column should by default provide a dropdown of Yes/No or similar, not a text box?


Phil.
0 link
Gleb
Gleb
Administrator
Posts: 41


10/2/2017
Gleb
Gleb
Administrator
Posts: 41
Fixed in 1.3. You should use new "Checkbox" field type for boolean columns.
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software