> i've got no idea! I use ... > Using both ZeosLib and SQLite Expert the SubTotal (and count > if inserted) is returned as text > >From the command line sqlite3 -- Loading resources from C:\Documents and Settings\Roger/.sqliterc SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select cast(((1.2*2.1)/100) as real); cast(((1.2*2.1)/100) as real) 0.0252 AND sqlite> select typeof(cast(((1.2*2.1)/100) as real)); typeof(cast(((1.2*2.1)/100) as real)) real
Maybe you should check with ZeosLib and SQLite Expert? //Roger _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
