servoy sequence - calculate from data question.

Classic Servoy
1

I’m importing data from an external application. I have a character type field that I would like to use with servoy sequence. If the rows contain:

100010
47
100011
Z52
62

and I recalculate the next sequence number from data, it calculates 63. So it is uses the character collating sequence instead of a numeric sequence. This will result in duplicates. Since it already strips out any non-numeric characters from the field when calculating the next sequence number (if I had a row that contained ‘Q701X’ in the above table, the next number calculated would be 702), should it not treat the numeric character portion of the field as an integer and return 100012?

2

Michael,

Servoy simply does a ‘select max(col) from tab’, we have no control over the returned value.
The next sequence value is based on this one.

Rob