In playing around with query results from back end servers we've noticed that the length of numeric columns in result cursors are longer than the definitions on the back end. For example, say you have a table with a column called rndlabpct that is defined in SQLServer or ORACLE as Numeric(1,0). Now query that table and then use AFIELDS() on the result cursor. With SQLServer as the back end, the cursor column is created as Numeric(3,0). With ORACLE, the cursor column is created as Numeric(2,0).
Is this behavior "by design" or is there some setting somewhere that would allow us to control this?
TIA
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
