I know sqlite stores data as text, but why does count(1) and cast(count(1) as integer) give a text result? more to the point, why does cast(((myfloatfield*myotherfloatfield)/100) as real) give a text result!
this is really irritating as i've put a lot of time into a project for someone only to be unable to complete it. im on latest 3.7.4 precompiled dll from sqlite website. im not seeing much else on the net for this at all, but it happens with different software using different sqlite 3 dll sub- versions. Thanks for any help, Jim. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
