On Sun, Jul 12, 2009 at 11:00 PM, tetragon tetragon<[email protected]> wrote:
> create table words (_id integer primary key autoincrement, wordtext text not
> null unique, timestamp integer not null);
>
> public class Word
> {
> long _id;
> String wordtext;
> long timestamp;
> }
>
> timestamp:
> before save: 1247435151517
> after save : 1247435160847
>
> Why is it doing this?
>
>
>
not for me...
[10:54 AM] ~$sqlite3
SQLite version 3.6.11
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table words (_id integer primary key autoincrement,
wordtext text not null unique, timestamp integer not null);
sqlite> insert into words (wordtext, timestamp) values ('foo', 1247435151517);
sqlite> select * from words;
1|foo|1247435151517
sqlite>
maybe your application?
--
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
