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

[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 back end (SQLite here); some
middleware code in the language of your choice for business logic,
reporting, etc.; and the UI that allows interaction with the application's
user. Presentation of output, and formatting of user input is done with the
UI code. Such formatting is not part of SQL.

Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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.14159265358979323846264338327950  Let the spirit of pi spread
2884197169399375105820974944592307  all around the world!
8164062862089986280348253421170679  http://pi314.at PI VOBISCUM!

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users