[sqlite] Order by table reads

Hi, i've a question about how to control the order in which sqlite reads tables. here is the basic setup: table foo (f_id integer primary key, foo text, prio integer); table bar (b_id integer primary key, bar text, prio integer); table foobar (fb_id integer primary key, f_id integer, b_id

Re: [sqlite] VC7 & VC8 Linker Errors

Im building as a static library with /MT (multithreaded) I just thought it was strange that none of the other libraries i build have similar problems and was wondering if anyone knew the specific cause ? On 5/21/07, Teg <[EMAIL PROTECTED]> wrote: Hello Emerson, How are you compiling it? /MT

[sqlite] SQL error: disk I/O error

I'm running the command line tool to create sqlite3 db. My directory permissions are drwxrwxrwt. I'm getting the following error. ./sqlite3 newdb SQLite version 3.3.12 Enter ".help" for instructions sqlite> create table tbl1(one varchar(10), two smallint); SQL error: disk I/O error If I try

Re: [sqlite] SQL error: disk I/O error

If you're using Linux, try: echo "create table t1(a);" |strace ./sqlite3 my.db 2>&1 |less and examine the output. See where it differs from the successful tmpfs run. Newer versions of sqlite3 may have better IO error messages. > I'm running the command line tool to create sqlite3 db. > My