Hi Nick. Yes, actually that leads me to another question. :)
I tried creating the field as INTEGER, but 10 digit numbers where imported as 0. I assume the field was created as 32 bit integer and invalid entries got a default value. I also tried LONGINT, BIGINT and INT64 but no joy. What would be the correct syntax for longer ints ? Nick Shaw schrieb: > Out of interest, is all the data in the artnr field numeric? If so, why > are you storing it as text and not an integer? Integer searching is > much, much faster. > > Nick. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users