> Could it be that since you're not defining a type for Data it assumes > string? > Try creating the table with > id integer, externalid integer, data number (or numeric)
That Data column could contain anything (int, double, string), it'll be up to the application's logic to only get Data for ExternalIDs that are numeric. I've confirmed it to work in 3.6.1 though - it doesn't work in 3.3.5. Thanks, Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
