[sqlite] idxchck

how to run idxchck under windows?

Re: Re: [sqlite] timestamp how to ?

sing the SQLITE >functions for date/time comparisons on the fly. They are fine for >formatting the data for display, but where I need to manipulate the >data I still retrieve the 'raw' integer value and convert it as I >require. > >-ken > >On 22-Apr-05, at 9:03 AM, [EMAIL PROTECTED

[sqlite] timestamp how to ?

hi how can i use timestamp value in sqlite i create table : create table sales (id integer not nul primary key, --- [this is time stamp information ??] bill_number integer, item_code integer, amount double); then i insert into sales:

Re: Re: [sqlite] optimize table

have you some feeling on my problem? cut or not cut db files? >-PÃvodnà sprÃva- >Od: D. Richard Hipp [mailto:[EMAIL PROTECTED] >OdoslanÃ: 15. aprÃla 2005 11:15 >Komu: sqlite-users@sqlite.org >Predmet: Re: [sqlite] optimize table > > >On Fri, 2005-04-15 at 06:15 -0400, Ken & Deb Allen

Re: Re: [sqlite] optimize table

TECTED] >Odoslané: 15. apríla 2005 7:13 >Komu: sqlite-users@sqlite.org >Predmet: Re: [sqlite] optimize table > > >msaka msaka wrote: >> >> CREATE TABLE sale( >>id INTEGER NOT NULL UNIQUE PRIMARY KEY, >>bill_no integer, >>bill_item_no i

[sqlite] optimize table

hi i create cashdesk system with sqlite 3. my qustions are: i insert sales into table sale: 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 ) table with