note
afoken
<p>I vaguely remember that you can pass some attributes to prepare or bind to help DBI / DBD::ODBC with the correct data types. In your case, you need to mark the result column as floating point number (instead of int / string). See bind_col in [mod://DBD::ODBC].</p>
<p>In general, DBI / DBD::ODBC should be able to auto-detect the type of any result column, but it seems that something got messed up with FoxPro. Perhaps FoxPro wrongly reports the column as some integer type at the ODBC level.</p>
<p>Alexander</p>
<div class="pmsig"><div class="pmsig-747201">
--<br>
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
</div></div>
1232884
1232884