Hi, It seems that if I create the table as a field type 'char' instead of 'string' then the issue is solved. But I thought the field type was of non importance?
rgds, Wilfried 2009/7/13 Wilfried Mestdagh <[email protected]> > Hello, > > I'm using sqlite3.dll and Delphi 7. In certain cirumstances a string seems > to be converted to a number. To test I use SQLiteSpy from Ralf Junker wich > is a nice tool. > > When I do this: > insert into Queue (NetworkID) values ("200907130833123740007") > > Then the result of the field NetworkID is: > 2.00907130833124E20 > > To solve this I add a blank in front of the ID, like this: > insert into Queue (NetworkID) values (" 200907130833123740007") > > But is this a good method, and is this a known issue? > > The table is created like this: > 'create table Queue (' + > '[NetworkID] string, ' + > '[State] integer, ' + > // Etc... > > -- > mvg, Wilfried > http://www.mestdagh.biz > -- mvg, Wilfried http://www.mestdagh.biz _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
