I use CAs to manage SQL Server data, but when I receive data some numeric fields (defined as numeric(6,2) or numeric(5,1) in SQL Server table) have values w/o first zero if they are empty. I get .00 or .0 instead of 0.00 or 0.0.
When I use CursorSchema for that cursorAdapter there is no difference. Even if I copy the result as VFP table and open it with HexEditor values are still .00 or .0. How can I get results with leading zero for that fields?
Strange thing is that for other fields I get correct (for me) results.
TIA
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.