(missed your message somehow) All 3 return integer in sqlite express (which is good), but zeos doesn't like typeof().
On 6 January 2011 09:12, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > 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