Hi Brendan,
ok – finally I bought the Mac-Version :)
There’s one general question:
What’s the reason for the two separate value fields (text_value, number_value) in the SQLite database? I’d expect to ‘convert’ the inputted value to text or to number (respectively). What happens now is, that I can enter 2 different values, which are kept both, if I switch the field type. (That’s a nice feature to hide a value, but IMO that’s rather confusing).
Any info?
andy
Hi Andy,
That’s just an internal implementation issue. If you have a Number field type, the values are stored in the number_value column. If it’s a text type field type, the values are stored in the text_value column. There is also boolean_value, etc.
If you switch types in the UI, I simply point to the other column to reference the data. Technically I probably should loop through all values and move them to the other column when you switch types. It would require data type conversion also.
Thanks,
Brendan
.
