>>Of course. You can change the table structure with an ALTER TABLE.
>
>I have a dream... <g> That means the user can now specify the number of decimals he wants to use and I can do an alter table (how to a diff matter) programatically on all the tables maybe based on a field name say ending with amt to this new decimals?
You don't need an ALTER TABLE for that. Use Double, specify a maximum amount of decimals (for instance 6), let the user choose a number of decimals (for instance, 0-6), and change the corresponding InputMask of relevant textboxes.
I think it is convenient to base the relevant textboxes on a class, with a property for the number of decimals. The number of decimals can be loaded from user preferences on Init(), and the InputMask changed accordingly.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)