Re: [sqlite] ROLLBACK TO savepoint cancels earlier RELEASEs

2012-05-10 Thread ext-Esko.Hujanen
On 9 May 2012, at 10:33am, ext-esko.huja...@elektrobit.com wrote: 1: SAVEPOINT 1 2: insert A 3: RELEASE SAVEPOINT 1 4: SAVEPOINT 2 5: insert B 6: ROLLBACK TO SAVEPOINT 2 ROLLBACK in line 6 cancels also line 2 in addition to line 5. I want to cancel just line 5. What it does

[sqlite] ANN: AnySQL Maestro 12.5

2012-05-10 Thread SQL Maestro Group
Hi! SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at

[sqlite] intial database creation

2012-05-10 Thread McSparin, Brett E
How does one go about creating a database initially in SQLite? Do you create a schema file for it to read or similar? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] intial database creation

2012-05-10 Thread Black, Michael (IS)
My preference is to create a file with an editor to spell out the tables and some example inserts and selects to test. Then you can easily just make some changes and re-read the file to test it again. Then you can run the sqlite shell and do this (example file is myfile.sql that you create)

[sqlite] using lemon

2012-05-10 Thread Baruch Burstein
Can anyone suggest a lexical scanner generator that: a) Works well with Lemon? b) Is also thread-safe (like Lemon)? Does Flex work well with Lemon? (I think it is not thread-safe, but it is very popular and has plenty of examples around, which is also a plus for me) I am trying to learn a little

Re: [sqlite] using lemon

2012-05-10 Thread Igmar Palsenberg
Can anyone suggest a lexical scanner generator that: a) Works well with Lemon? b) Is also thread-safe (like Lemon)? Does Flex work well with Lemon? (I think it is not thread-safe, but it is very popular and has plenty of examples around, which is also a plus for me) I am trying to

Re: [sqlite] using lemon

2012-05-10 Thread Richard Hipp
On Thu, May 10, 2012 at 4:59 PM, Baruch Burstein bmburst...@gmail.comwrote: Can anyone suggest a lexical scanner generator that: a) Works well with Lemon? b) Is also thread-safe (like Lemon)? Does Flex work well with Lemon? (I think it is not thread-safe, but it is very popular and has

Re: [sqlite] intial database creation

2012-05-10 Thread Mircea Neacsu
Same basic advice as Michael. If I may add however, you make a separate SQL file with just the database schema and put it under version control same way you would do with any other source file. Other test cases and sample queries can also be version controlled but would probably be separate

[sqlite] ef58535776bab0affdf741ab0510666330682121

2012-05-10 Thread ????
open database,the error information is as follows.please help resolve? Thanks so much! Error:database disk image is malformed! Sqlite_master's Field List Failed: database disk image is malformed! ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] intial database creation

2012-05-10 Thread Teg
Hello Brett, All of my DB's are generated in code. When I version control the code, I'm also version controlling the schema. If my users end up with bad DB's (it's windows, it happens fairly frequently). They just delete them and they're then re-created as needed by the program. I have specific