Re: [sqlite] [OT] Re: Tool for database designer

2011-09-19 Thread George Brink
On 9/19/2011 1:24 PM, Petite Abeille wrote: On Sep 19, 2011, at 7:02 PM, George Brink wrote: You can use PowerDesigner Trivia #1: PowerDesigner download weights 390 MB. This compares to 1.4 MB for SQLite. By weight, PowerDesigner does not provide 390 times the value of SQLite. Trivia #2

Re: [sqlite] Tool for database designer

2011-09-19 Thread George Brink
On 9/19/2011 1:13 AM, Madhan Kumar wrote: I want to design the table structure and create scripts with a database designer Do we have any tool(Free or cost) for Sqlite to design the tables, similar like powerdesigner. You can use PowerDesigner, just select 'ANSI Level 2' for DBMS.

Re: [sqlite] error:library routine out of sequence

2011-08-30 Thread George Brink
Yes, q.finalize() should close the previous query. But that is not the point here. All query objects are build upon the same resource (database connection). This resource cannot be shared between two queries. They have to be created and killed sequentially. CppSQLite3Query q1=

[sqlite] fts3 table name cannot be the same as column name

2011-08-18 Thread George Brink
I think this is a bug... If you trying to create FTS3/FTS4 table, make sure that column name in FTS table is not the same as the table name. C:\Projects>sqlite3 aaa SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create

[sqlite] cannot compile SQLite 3.7.7.1 with ICU 4.8.1 on windows

2011-08-09 Thread George Brink
Environment: Windows XP, MinGW+MSYS ICU configured with: sh runConfigureICU MinGW --enable-static --enable-shared make && make install Produces several libraries (both static and shared). Attempting to compile sqlite-amalgamation-3070701: gcc -osqlite3 sqlite3.c shell.c

Re: [sqlite] SQLITE return codes for insert/delete/update/select

2011-05-12 Thread George Brink
On 5/11/2011 3:52 PM, cricketfan wrote: > > I dont know if it is just me but I find the return codes for SQL operation > quite confusing. I am new to SQLITE, have learnt a few things and wanted to > know if going in the correct direction, You are thinking in the wrong direction. SQLITE_DONE means