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
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
