Re: [sqlite] It's done, except for this nit:

2009-11-29 Thread Rich Shepard
On Sun, 29 Nov 2009, Ted Rolle, Jr. wrote: > I need for computed total price to display with leading and trailing > zeros. > E.g. > 1 -> 1.00 > 2.5 -> 2.50 > .9 -> 0.90 Ted, It is most common to handle display issues in the UI component. _Most_ applications have three components: a database

[sqlite] It's done, except for this nit:

2009-11-29 Thread Ted Rolle, Jr.
I need for computed total price to display with leading and trailing zeros. E.g. 1 -> 1.00 2.5 -> 2.50 .9 -> 0.90 The extended price is computed with this statement: round(purchase.qty*inventory.price/100.0,2) Ted 3.1415926535897