[sqlite] Obtaining the database file name

2004-01-02 Thread Bronislav Klučka
Hi, I have pointer returned from sqlite_open function call, how can I obtain the file name of the database having just that pointer? I could'n fing any API to do it. Brona - To unsubscribe, e-mail: [EMAIL PROTECTED] For

RE: [sqlite] SQLITE_SCHEMA error

2004-01-02 Thread Bronislav Klučka
> Bronislav Klučka <[EMAIL PROTECTED]> writes: > > > PLIIZ HELP ME > > > >> > > I've read the documentation, where is written: "When the > database first > >> > > opened, SQLite reads the database schema into memory and uses that > >> > > schema to parse new SQL statements. If another process

Re: [sqlite] Selecting row containing max value

2004-01-02 Thread D. Richard Hipp
Bronislav Klučka wrote: Hi, I've got a table "state" which holds states for products, every insert made on this table is inserting values and value called "whenaction" where is the time (as timestamp) of the insert, so table cound look like this: id|amount|product_id|whenaction 1 50 2