Re: [sqlite] sqlite-3.3.4 and extra float decimals

2006-04-06 Thread John Stanton
Dennis Cote wrote: Floppe wrote: Will Leshner wrote: On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, When using sqlite-3.3.4 with windows I get the following strange behaviour. create table Muppet (Kermit float); insert into Muppet values (100); select * from Muppe

Re: [sqlite] sqlite-3.3.4 and extra float decimals

2006-04-06 Thread Dennis Cote
Floppe wrote: Will Leshner wrote: On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, When using sqlite-3.3.4 with windows I get the following strange behaviour. create table Muppet (Kermit float); insert into Muppet values (100); select * from Muppet; 100.0

Re: [sqlite] sqlite-3.3.4 and extra float decimals

2006-04-05 Thread Floppe
Will Leshner wrote: > On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> Hello, >> >> When using sqlite-3.3.4 with windows I get the following strange behaviour. >> >> create table Muppet (Kermit float); >> insert into Muppet values (100); >> select * from Muppet; >> 100.0 >> > >

Re: [sqlite] sqlite-3.3.4 and extra float decimals

2006-04-05 Thread Will Leshner
On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, > > When using sqlite-3.3.4 with windows I get the following strange behaviour. > > create table Muppet (Kermit float); > insert into Muppet values (100); > select * from Muppet; > 100.0 That's not strange. Kermit is defined to be a

[sqlite] sqlite-3.3.4 and extra float decimals

2006-04-05 Thread sqlite
Hello, When using sqlite-3.3.4 with windows I get the following strange behaviour. create table Muppet (Kermit float); insert into Muppet values (100); select * from Muppet; 100.0 As you see it returns 100.0 instead of only 100. This happens in windows xp but not in win ce. Anyone know how to f