If a field contained a numeric value that was unusually large (>= !E17) then any attempt to select that field as a character field caused the select to fail with error 5210 (Invalid number). Now fields that are too big for the allotted character field are converted to "??????". Unfortunately, there is still no way to select such data in character format as SQLLIBT always uses length 17 for numeric fields and does not use floating point format. The data can be selected and displayed properly as a number, assuming the program can do its own conversion to characters successfully, for example by using sprintf().
SQL did not display negative values properly, and what is worse blanked all remaining data on the line!!
This problem also affects the 16 bit SQL library SQLLIBW.DLL, and the SQL and SQLEXE programs.
Where the version affected is given as 4.5xx or 4.6xx, all versions of DP4 issued prior to the date of the fix are potentially affected. Where a specific version number is given the problem was introduced by that release and prior releases are unaffected. If a patch release number is also specified (in parentheses) , the fault was introduced at that specific patch level.
Due to limitations on available web space downloadable fixes are only available for the most commonly used environments, and may not be separately available in both 4.5xx and 4.6xx flavours. If a file you require is not available you can ask us to e-mail it to you.