If you use a view to return a double, you've lost the exact value you
were trying to save by storing the decimal as a text value. If you
continue to work with it as an integer, it's exact, but that requires
continual awareness of the number of decimal places at any point in
time. In essence, you have to build significant numeric
infrastructure into your program to emulate the missing numeric
infrastructure in SQLite.
Patrick Earl
On Sat, Mar 26, 2011 at 9:52 PM, BareFeetWare <list....@barefeetware.com> wrote:
> On 27/03/2011, at 2:09 PM, Patrick Earl wrote:
>
>> if you're in a context where you don't have significant understanding of the
>> user's query, how do you determine if 1.05 is $1.05 or 105%?
>
> Can you give us a bit more background and an example of this?
>
> How is the interface for the query represented to the user and what can they
> enter there to create a query?
>
> You can probably do this fairly easily via views which display data in a
> particular format for the user to see or create a query.
>
> Tom
> BareFeetWare
>
> --
> iPhone/iPad/iPod and Mac software development, specialising in databases
> develo...@barefeetware.com
> --
> Comparison of SQLite GUI tools:
> http://www.barefeetware.com/sqlite/compare/?ml
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
