>The View Designer keeps removing my leading Zeros that I am using to create an editable view to be used to post data to a table for. I can put in an expression such as 0000.00 AS 'SomeField' into the Expression Builder. Then when I go to edit the View again it only as 0.00 AS 'SomeField' in the field.
>
>I am using the leading zeros to provide for entering up to 4 digits prior to the decimal place in the field. If it only has one Zero in the field then I can only enter one number prior to the decimal place in the grid.
>
>Any good ideas as to a work around?
You could brute-force it by using 9999.99 instead, but that means initializing the column in your app.
In a separate thread, Cindy Winegarden pointed out that sometimes you can use expressions like
0 + 0000.00 AS...
to work around this.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up