Re: [sqlite] PRAGMA table_info(second.table)

You should look more closely at the syntax for the Pragma statement. What you need is: PRAGMA test.table_info(tab1); This makes sense when you consider not all pragmas have arguments. Peter On 6/4/2014 11:19 PM, LacaK wrote: Hi, when I attach database using f.e ATTACH DATABASE 'test.db' AS

Re: [sqlite] Corrupted database files

On 5 Jun 2014, at 1:16pm, Lasse Jansen wrote: > Thanks, spawning another process is a good idea. If you're going to continue to use SQLite in your own code on a Mac I encourage you to include the amalgamation files (.h and .c) rather than referring to a dynamic library.

Re: [sqlite] PRAGMA table_info(second.table)

On 6/5/2014 2:19 AM, LacaK wrote: Then when I try PRAGMA table_info(test.tab1) , I get error: near ".": syntax error. The correct syntax is PRAGMA test.table_info(tab1) ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] PRAGMA table_info(second.table)

Hi, when I attach database using f.e ATTACH DATABASE 'test.db' AS tets; and in attached database is f.e. table "tab1". Then when I try PRAGMA table_info(test.tab1) , I get error: near ".": syntax error. Is it expected ? (of course SELECT * FROM test.tab1 works as expected ...) Thanks -Laco.

Re: [sqlite] Corrupted database files

Thanks, spawning another process is a good idea. Filing a bug with Apple is probably not going to work, they don't encourage accessing a CoreData managed database without going through CoreData. 2014-06-05 13:49 GMT+02:00 David Empson : > On 5/06/2014, at 11:21 pm, Lasse

Re: [sqlite] Corrupted database files

Thanks for the suggestion, I think I'll try this. I probably need to detect the kind of error and use some retry-mechanism ... 2014-06-05 13:35 GMT+02:00 Richard Hipp : > On Thu, Jun 5, 2014 at 7:21 AM, Lasse Jansen wrote: > > > Hi, > > > > we have a Mac

Re: [sqlite] Corrupted database files

Unfortunately CoreData is closed source and is distributed as part of the Mac OS X SDK so there is no way to update it. 2014-06-05 13:33 GMT+02:00 RSmith : > > On 2014/06/05 13:21, Lasse Jansen wrote: > >> Hi, >> >> we have a Mac app that uses CoreData which internally uses

Re: [sqlite] Corrupted database files

On 5/06/2014, at 11:21 pm, Lasse Jansen wrote: > Hi, > > we have a Mac app that uses CoreData which internally uses SQLite. Some of > the queries are not expressible within CoreData, so we send them manually > using the sqlite library that comes with Mac OS X. Now some of

Re: [sqlite] Corrupted database files

On Thu, Jun 5, 2014 at 7:21 AM, Lasse Jansen wrote: > Hi, > > we have a Mac app that uses CoreData which internally uses SQLite. Some of > the queries are not expressible within CoreData, so we send them manually > using the sqlite library that comes with Mac OS X. Now some

Re: [sqlite] Corrupted database files

On 2014/06/05 13:21, Lasse Jansen wrote: Hi, we have a Mac app that uses CoreData which internally uses SQLite. Some of the queries are not expressible within CoreData, so we send them manually using the sqlite library that comes with Mac OS X. Now some of our users have reported that their

[sqlite] Corrupted database files

Hi, we have a Mac app that uses CoreData which internally uses SQLite. Some of the queries are not expressible within CoreData, so we send them manually using the sqlite library that comes with Mac OS X. Now some of our users have reported that their database file got corrupted and after some