Quote: "Hmmm, ok maybe I am just looking at this wrong. I thought that maybe it would look at the datatype of the variable I am assigning (in this case number3#) and perform the appropriate method (integer or float) based on what I am asking for."
Yes, generally that would make sense, but there are some problems that can occur when passing such expressions to (internal) functions, such as
MyString = Str$(5/2)
So should this be an integer, or float division?
For inbuilt functions DBpro uses overloading, ie. there is one Str$ function that requires an integer type argument, and another one that requires a float type argument, so the compiler has to decide what type the result of an expression is.