Well the problem I have is like this, the first is that I do not have access to the database, and the main problem is, I get from this database, data, it turns out that when I get a column with values, they do not respect the numerical order, for example; 1,11,132,145,186,2,22,234,257,3,4. that is an example, it only respects the first digit to the left. Another thing I noticed is that in the db, they use varchars instead of an integer, my question is, if I can not access the database, is it possible to change by means of a filter, or by means of some expression the format? I already tried to call my recordtype, with a cast, but it sends me an error when I do it from my recordlist for filters.
for example
tointeger(recordtypebdd.fields.values) and I get an error...
I hope you can help me.
Discussion posts and replies are publicly visible
Add a custom record type field and cast this field data as integer. Hope this will works.