Problem with numeric blank fields
Tanks a lot.
Iaacov
"Peter Jamieson" лъб
...
Any better idea?
No, sorry.
Assuming there are two possible problems:
a. the ASA ODBC driver is not returning the data correctly
b. MS Query/Word are not dealing with SQL_NUMERIC data correctly
I suppose I would have to try to seek a solution from ASA for (a) and from
Microsoft directly for (b) (I don't work for them - you would need to
contact their support function or Customer services directly).
What I do know is that there are, or have been, problems with Currency
data in Access and Excel in the past. Those problems could well be related
to the one you are seeing. When I looked at the problem several years ago,
my best guess was that there might be an an error somewhere in a numeric
routine used in more than one place in MS software. It really was nothing
more than a guess, but perhaps someone in Microsoft knows more about it.
Peter Jamieson
|