[sqlite] Problem with warning: SQL error or missing database

Hi, I have met some problems when I opened the same database file twice in the same process. #include #include #include #include int main (int argc, char * argv[]) { sqlite3 * db1 = NULL; sqlite3 * db2 = NULL; sqlite3_stmt * pstmt = NULL; gchar * errorstr = NULL; gint ret; gint test_num =

Re: [sqlite] pragma table_info(...) documentation?

On Thu, 27 Apr 2006, Dan Baker wrote: [...] It appears to return 6 columns of data per table-column. I believe they are as follows: [1] = column# (0...) [2] = column name [3] = column affinity/type [...] [4] = flag: is the column NOT NULL? [5] = default value of the column [6] = flag: is

Re: [sqlite] pragma table_info(...) documentation?

On 4/27/06, Dan Baker <[EMAIL PROTECTED]> wrote: > I'm needing to find some information about a table, and the table_info > pragma seems to be the right ticket. > > I've looked around, and failed, to find any documentation on this cool > pragma. > It appears to return 6 columns of data per

[sqlite] pragma table_info(...) documentation?

I'm needing to find some information about a table, and the table_info pragma seems to be the right ticket. I've looked around, and failed, to find any documentation on this cool pragma. It appears to return 6 columns of data per table-column. I believe they are as follows: [1] = column#

[sqlite] Creating 3.3.5 dylib on OSX 10.4

Hi I have followed the normal steps mkdir bld cd bld ../configure make there are no messages suggesting that any errors occurred in the .libs folder I see dylib files but they are all over 1MB, where as the binary in /usr/lib or from the starkit on www.sqlite.org are around 320Kb. When

Re: [sqlite] sqlite3 in Makefile

Thanks, now it works fine! Best regards Danilo. Home Page: http://www.digitazero.org giovedì 27 aprile 2006, 10.54 Merijn

RE: [sqlite] sqlite3 in Makefile

We have a batchfile like this: sqlite3 internal.db3 < internal.txt Where internal.txt is a textfile containing all sql instructions needed to recreate our internal.db3 database. Best regards, Merijn Vandenabeele -Oorspronkelijk bericht- Van: Danilo [mailto:[EMAIL PROTECTED]

[sqlite] sqlite3 in Makefile

Hi to all, I'm trying to insert in Makefile a command to import a database's dump, but when execute the line it appears the prompt of sqlite, so I have to insert the .quit command. How can I run sqlite3 in batch mode? The Makefile is: