Re: [sqlite] Dealing with 2 versions of SQLite

2004-07-22 Thread Nuno Lucas
Darren Duncan, dando pulos de alegria, escreveu : That doesn't sound right. sqlite3_open() *should* return an error when you try opening a 2.x database, citing that the file is not a SQLite (v3) database file. I already noticed this, but I think of it as a feature (but it should be well

Re: [sqlite] Dealing with 2 versions of SQLite

2004-07-22 Thread Darren Duncan
At 3:03 PM -0300 7/22/04, Mauricio Piacentini wrote: When I open a SQLite 2.8.x db with sqlite3_open() I do not get any errors. I can even call sqlite3_exec() on it with some pragma commands, no errors returned. However when I attempt to retrieve more info (the table structure) I get error code

Re: [sqlite] Dealing with 2 versions of SQLite

2004-07-22 Thread Mauricio Piacentini
D. Richard Hipp wrote: SQLite 2.8 and SQLite 3.0 can peacefully coexist. They can even be linked together into the same binary. I have just done this for inclusion in the next version of the SQLite DB Browser, and it works great. The only problem is how to identify the file format when I open a

Re: [sqlite] Dealing with 2 versions of SQLite

2004-07-22 Thread gohaku
I reinstalled DBD-SQLite, will that Perl module know which version of SQLite to use? On Jul 21, 2004, at 10:37 PM, D. Richard Hipp wrote: gohaku wrote: I just installed SQLite v3.0.0. However, I still have v2.8.11 of the SQLite interpreter ( sqlite ) on my system. I would like to know the