Let's suppose we have a table with a REAL and an INT, and let's lay it out
left to right as below:
REAL1 INT1
.0599 NULL
.0600 NULL
.0601 NULL
.0698 NULL
.0699 NULL
.0700 NULL
.0701 NULL
Now, let's use the update command to set INT1 to the value of REAL1 * 10000.
What would you expect? Well, I expect something other than what I'm getting.
The results are as follows:
REAL1 INT1
.0599 599
.0600 599
.0601 601
.0698 697
.0699 698
.0700 700
.0701 701
What gives??
wwwww
( @ @ )
-------oOO---(_)---OOo-------
Damon J. Gray
Anvil Corporation Business Services
(360) 937-0770
oooo0 0oooo
( ) ( )
----------\ (----) /-----------
\__) (__/