Home Back E-mail



Overcoming the truncate bug in FileMaker Pro 4.0x


Under FileMaker Pro 4.0x (not 5.0x) the Truncate function cannot be used - e.g. for field validation - due to a severe bug.

You can easily bypass this problem by using the following field validation:

n_numberfield * 100 = int(n_numberfield * 100)
This holds for 2 decimals. If you want 3 or more decimals, simply change both "100" into "1000" etc.

Good luck!

Back to the list of my FileMaker Pro trouvailles

Home Back to Christoph Bouthillier Top

© 1997...