I have found the problem. There was an incrementing trigger left in
the database accidentally.
- Original Message -
From: "John Machin"
To: "General Discussion of SQLite Database"
Sent: Sunday, July 12, 2009 4:25 PM
Subject: Re: [sqlite] Number truncation problem i
On 13/07/2009 8:40 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Jim Showalter wrote:
>> create table words (_id integer primary key autoincrement, wordtext
>> text not null unique, timestamp integer not null);
>>
>> public class Word
>> {
>> long _id;
>> St
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim Showalter 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:
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
64-bit max is: 9223372036854775807
4 matches
Mail list logo