After investigating a number of fox (5.0) database problems, we are shocked to discover that it is possible to create a table with a numeric field that has a width of say 5 and decimals of say 3 then store a value of 12345 in this fields. For example:

create cursor billy ( numfield n(5,3))
insert into billy values 12345

Has anybody else looked into this? and can it be a cause of some of the indexing problems that we are currently suffering from? Is this fixed in 6.0?

Thanks

Macer