Quote:
|
so the database will automatically remove the leading zeroes when storing it
|
Ok, now that is an interesting piece of information!
So even if I store the series-index with the leading zeros in the series_index itself the DB will remove it anyway. Hm, time for a feature request I think
.
Now, just some more questions: This script does not create the new column, right?
I just create a new one "of type text". Why Text when I put numbers in it? Numbers are text as well!?
And I can find it in Metadata by searching for #my-column I guess?
Btw I like the part of the script "import math". What does it do? Math, obviously ^^.
Edit: I created a new column called Index and found it in the metadata under #index. Nice. So I try your script in a few minutes and see if the DB implodes.
Edit 2: It didn't implode, that's the good news. It wrote something, that's the other good news. But instead of the numbers, in the #index column is now: {0:02.0f}
What ever that means. Any ideas what I did wrong?
Edit 3: There were no errors or anything.
st.