[Gambas-user] Problems retrieving the original values

[nando]

SQLite REAL  is 8B IEEE floating point number
Gambas FLOAT is the exact same thing.

1. Make sure your Gambas var is FLOAT and not SINGLE
2. What you see 5.819279E+8 is only a visual representation to humans of
   what the value really is.  Use FORMAT$ to represent it differently the
   way you want.

-Fernando


---------- Original Message -----------
From: "M. Cs." <mohareve at ...626...>
To: mailing list for gambas users <gambas-user at lists.sourceforge.net>
Sent: Thu, 17 Dec 2009 11:21:03 +0100
Subject: [Gambas-user] Problems retrieving the original values

> I have a database file in Sqlite which has a REAL type field.When I browse
> the database in a terminal I have a value 581927884.0, but when I retrieve
> it to a table!"Size" variable it prints out as 5.819279E+8 which makes
> troubles for me. Can I have the original number format?
> ------------------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev 
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
------- End of Original Message -------