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.
Back to the list of my FileMaker Pro trouvailles