Re: [sqlite] German umlauts (äöüß) are not displayed in sqlite - solution

Wolfgang Hello, you can try SQLite Spy [1] for that. It shows Unicode-Chars correctly. [1] http://www.yunqa.de/delphi/sqlitespy/ Regards, A. Klitzing signature.asc Description: OpenPGP digital signature

Re: [sqlite] Prepared statements and temp ffiles

Jay Sprenkle schrieb: On 9/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: The only way I know to provide some approximation of random access cursors for queries like the above is to store the complete result of the query in a temporary table. You can always do so by prepending: Did anyon

Re: [sqlite] Prepared statements and temp ffiles

Now if you follow this strategy, notice that you never need to keep pending read operations around. The original query builds the temp table in a single sqlite3_step() call. To access the results, you prepare a statement like this: SELECT * FROM result_set_1 WHERE rowid=? Of course you

[sqlite] Re: sqlite3_step() vs. get_tables() - CPU-Usage

Thanks, I think I will write my own 'cache' with sqlite3_step(). signature.asc Description: OpenPGP digital signature

[sqlite] sqlite3_step() vs. get_tables() - CPU-Usage

Hello, I need some information about the sqlite3_step() function. How much CPU-usage does it need in comparison with sqlite3_get_tables()? I have to implement functions like next(), prev(), last(), first(), relative(int) and absolute(int). #1 Way - sqlite3_step() I can only step forward with s

[sqlite] SQLite 2.8.17 - Interface

Hello, I just wanted to ask if there is an interface change from version 2.8.16 to 2.8.17? Because I need to know it for Ubuntu Dapper. https://launchpad.net/distros/ubuntu/+source/sqlite/+bug/36732 Thanks, A. Klitzing