Re: [sqlite] Possible 1GB database limit on Windows from PENDING_BYTE

2005-05-16 Thread Gert Rijs
D. Richard Hipp wrote: On Mon, 2005-05-16 at 15:58 +0200, Helmut Tschemernjak wrote: thank you for the info, another possible problem is that I cannot backup the database e.g. "begin exclusive" and copy the entire DB file while the main server app is still running. The copy aborts at offset 1GB.

Re: [sqlite] optimize table

2005-04-15 Thread Gert Rijs
msaka msaka wrote: CREATE TABLE sale( id INTEGER NOT NULL UNIQUE PRIMARY KEY, bill_no integer, bill_item_no integer, item_name varchar(20), qty integer, amount DOUBLE, statistic integer ) Why don't you replace "statistic" with a timestamp formatted like mmdd, perhaps add

Re: [sqlite] Prepared Statement Interface

2005-03-26 Thread Gert Rijs
Eric Bohlman wrote: Eugene Wee wrote: #define SEX "'M'" And make that #define SEX "M" Gert