Macer ---

A quick fix to that one: Add the field-level rule to numfield:

numfield <= 999.99

No more problem :-)


>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