>Good Day all!
>
>My question is this...I have a field in my table called OrderId it is 7 characters long. If an id is entered that is three characters (ex. 123) I would like to have it replaced with leading zeros to the max of C(7) (ex. 0000123). Is this possible to do in the table designer..input mask or format fields? Any other suggestions?
In a textbox, you can have .Format='L' and .InputMask='99999' but it will only display leading zeros; it won't transform whatever the user input is.
In a DBC, it works the same for numeric fields, but not for character. You may
replace all c7field with tran(value(c7field), "@L 9999999")
if you need to do it post festum.
(jel' zima tamo gore?)