On 6 Jan 2011, at 4:00am, Vannus wrote: > Using both ZeosLib and SQLite Expert the SubTotal (and count if inserted) is > returned as text
The documentation for ZeosLib appears to be in '.chm' files. I can't read that format. SQLite Expert is a database admin system, not a programming API. It doesn't need to support typing. My guess is that it handles everything that isn't a direct copy of a column value as text, which would be the simplest way to write such a program. > SELECT > Orders.ID AS OrderID, > Mixes.ID AS MixID, > Mixes.Percentage AS Percentage, > /* count(1),*/ > /* cast(cout(1) as integer), */ > /* 1 as one,*/ > /* cast(1 as integer) AS one,*/ > (Orders.Total/100)*Mixes.Percentage AS SubTotal > FROM > Orders, Mixes Execute SELECT typeof(Orders.Total/100), typeof((Orders.Total/100)*Mixes.Percentage), typeof(count(Orders)) FROM Orders, Mixes and see what you get. We assure you that as far as we know, SQLite handles such numbers as numbers rather than text. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
