>>>Hmm, interesting. I didn't know you could use PADL() with a general expression, I thought it had to be a string.
>>
>>tnNumero comes from an object property This.nNumero which is initialize from a cursor field which comes from a table on an integer field. So, if I select a field in a cursor that is an integer, store that in a property, I should end up with the proper value.
>
>Doesn't matter. The minute you have PARAMETER/LPARAMETER tnNumero, you've done an implicit conversion to numeric, not integer. In fact, it probably happened on storing it to the object property - I don't believe object properties can be integers, either.
>
>>
>>IAC, as I said, I have this at various other levels as well. I have experienced this with VFP 9. Basically, I read a HTML form value with WWC object, such as Request.Form, and sometimes, I end up as well with that behavior when getting the VAL() value of what Request.Form returns. It simply just doesn't make any sense. I have started to put INT() mostly everywhere I am using PADL() now.
>
>Like I said, you'll need to include ROUND() for it to be bulletproof. The joys of decimal/floating point approximations of integers ...
What if you specify as INTEGER in your parameters declaration?
If it's not broken, fix it until it is.
My Blog