Re: [sqlite] Bug in sqlite.exe? NOT !

: November-30-13 20:21 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? NOT ! The virtualization and UAC caused many a headache for unsuspecting programmers not used to the Linux way. It's a brilliant new way they do it but they had to move from an old way to a the new way in a way

Re: [sqlite] Bug in sqlite.exe? NOT !

so that non-admins can see the same file as admins... Eric -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch Sent: November-30-13 16:15 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? M

Re: [sqlite] Bug in sqlite.exe? NOT !

...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch Sent: November-30-13 16:15 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? Marcus Grimm wrote: > You have the DB file in ProgramData, maybe you are a victim of the > windows file virtuali

Re: [sqlite] Bug in sqlite.exe?

Marcus Grimm wrote: > You have the DB file in ProgramData, maybe you are a victim of the > windows file virtualization ? Given the symptoms, this is very likely. See . Regards, Clemens ___ sqlite-users mailing

Re: [sqlite] Bug in sqlite.exe?

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Keith Medcalf Sent: November-30-13 15:11 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug in sqlite.exe? Why are you using an alternate stream for the directory? >-Original Message- >From: sqlite-users-boun...@sqli

Re: [sqlite] Bug in sqlite.exe?

se >Subject: Re: [sqlite] Bug in sqlite.exe? > > >On 30 Nov 2013, at 7:03pm, Eric Teutsch <er...@powersoft.ca> wrote: > >> I've taken a picture of the odbc tool (showing the tables and the >database >> name) and sqlite.exe with .database and .table showing. Yo

Re: [sqlite] Bug in sqlite.exe?

er and see if that changes... Marcus -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Eric Teutsch Sent: November-30-13 14:04 To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Bug in sqlite.exe? I've taken a picture of the

Re: [sqlite] Bug in sqlite.exe?

e Database Subject: Re: [sqlite] Bug in sqlite.exe? On 30 Nov 2013, at 7:03pm, Eric Teutsch <er...@powersoft.ca> wrote: > I've taken a picture of the odbc tool (showing the tables and the database > name) and sqlite.exe with .database and .table showing. You can see it > here: http

Re: [sqlite] Bug in sqlite.exe?

On 30 Nov 2013, at 7:03pm, Eric Teutsch wrote: > I've taken a picture of the odbc tool (showing the tables and the database > name) and sqlite.exe with .database and .table showing. You can see it > here: http://www.powersoft.ca/files/sqlite.png > It's the same file...

Re: [sqlite] Bug in sqlite.exe?

of SQLite Database' Subject: Re: [sqlite] Bug in sqlite.exe? I've taken a picture of the odbc tool (showing the tables and the database name) and sqlite.exe with .database and .table showing. You can see it here: http://www.powersoft.ca/files/sqlite.png It's the same file... -Original Message

Re: [sqlite] Bug in sqlite.exe?

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: November-30-13 13:13 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? On 11/30/2013 11:55 AM, Eric Teutsch wrote: > .Tables doesn't show the 2 new tables. A select statement on one of > those table

Re: [sqlite] Bug in sqlite.exe?

On 11/30/2013 11:55 AM, Eric Teutsch wrote: .Tables doesn't show the 2 new tables. A select statement on one of those tables says "No such table". And "select * from sqlite_master" shows the 8 tables and 1 trigger. And ends there. But when using sqliteodbc, I can run the select statement on

Re: [sqlite] Bug in sqlite.exe?

Database Subject: Re: [sqlite] Bug in sqlite.exe? On 30 Nov 2013, at 5:43pm, Eric Teutsch <er...@powersoft.ca> wrote: > That is an interesting concept and could explain another weirdness - > my sqliteodbc connection always tells me that the database is > readonly. Is there a

Re: [sqlite] Bug in sqlite.exe?

On 30 Nov 2013, at 5:43pm, Eric Teutsch wrote: > That is an interesting concept and could explain another weirdness - my > sqliteodbc connection always tells me that the database is readonly. Is > there a way to find out if a database is in a transaction and waiting for a >

Re: [sqlite] Bug in sqlite.exe?

On 30 Nov 2013, at 3:01pm, Eric Teutsch wrote: > Hi, I've got a database (3.7.16.1) which has a bunch of tables and 2 > triggers. The order of creation is 8 tables, 2 triggers, 2 tables. When > looking at the database with the ODBC client (sqliteodb 0.992), I can see >

Re: [sqlite] Bug in sqlite.exe?

...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Keith Medcalf Sent: November-30-13 12:11 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug in sqlite.exe? COMMIT ? >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-

Re: [sqlite] Bug in sqlite.exe?

of SQLite Database Subject: Re: [sqlite] Bug in sqlite.exe? Try using SQLite Expert (For your short term use, use the free version) and see if you can pull up the DB. You can select which DLL you want to use and see if its a library issue or if its something to do with the database, or whatever else

Re: [sqlite] Bug in sqlite.exe?

COMMIT ? >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Eric Teutsch >Sent: Saturday, 30 November, 2013 09:56 >To: 'General Discussion of SQLite Database' >Subject: Re: [sqlite] Bug in sqlite.exe? >

Re: [sqlite] Bug in sqlite.exe?

No, all names are without spaces. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mohit Sindhwani Sent: November-30-13 11:59 To: General Discussion of SQLite Database Subject: Re: [sqlite] Bug in sqlite.exe? On 1/12/2013 12

Re: [sqlite] Bug in sqlite.exe?

On 1/12/2013 12:55 AM, Eric Teutsch wrote: .Tables doesn't show the 2 new tables. A select statement on one of those tables says "No such table". And "select * from sqlite_master" shows the 8 tables and 1 trigger. And ends there. But when using sqliteodbc, I can run the select statement on a

Re: [sqlite] Bug in sqlite.exe?

al Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: November-30-13 11:36 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Bug in sqlite.exe? On 11/30/2013 10:01 AM, Eric Teutsch wrote: > But when I look at the d

Re: [sqlite] Bug in sqlite.exe?

On 11/30/2013 10:01 AM, Eric Teutsch wrote: But when I look at the database with sqlite.exe (3.8.0.1), I see the 8 of tables and 1 trigger. I cannot query the remaining two tables. Define "cannot". Exactly what happens when you try? What do you mean by "see" - see where and how? Can you

Re: [sqlite] Bug in sqlite.exe?

Try using SQLite Expert (For your short term use, use the free version) and see if you can pull up the DB. You can select which DLL you want to use and see if its a library issue or if its something to do with the database, or whatever else. I have a bunch of DLLs in my VCS that I can extract

[sqlite] Bug in sqlite.exe?

Hi, I've got a database (3.7.16.1) which has a bunch of tables and 2 triggers. The order of creation is 8 tables, 2 triggers, 2 tables. When looking at the database with the ODBC client (sqliteodb 0.992), I can see 100% of the tables (I use QTADO as my interactive tool, and it doesn't show