[sqlite] Problems with the Tcl extension (when threaded)

Hello! I've downloaded sqlite-3_3_5-tea and compiled it correctly. It generates libsqlite335.so perfectly, but there is a problem. I compiled it with threads (I did ./configure --enable-thread and I checked -DTHREAD_SAFE=1 in the Makefile) but I can't write to the same database/table at the same

Re: [sqlite] Trying to determine if a column exists through a SQL Statement...

On Fri, 12 May 2006, Josh wrote: With MySQL I would simply do: SHOW COLUMNS FROM `war3users` LIKE 'playerip'; Can I do something similar in SQLite ? [...] Hello Josh, as far as I know, exactly equivalent functionality does not exist in SQLite3. But you can use the data you get via PRAGM

Re: [sqlite] library routine called out of sequence

My answer wasn't complete. If you populate a database using sqlite3 and exit sqlite3 the DB is closed. To access it from a C program you have to first open it with sqlite3_open. Sqlite is not an SQL server but instead a library which is linked into every application. Think of it just as a s

Re: [sqlite] library routine called out of sequence

The sqlite3 program automatically opens the database and holds it open. It will create one if it is missing. The DB stays open until you exit Sqlite3. JS Davide Berti wrote: execute sqlite3 test.db < myscript from a bash shell. myscript creates a few tables. After running this, is my tes

[sqlite] Trying to determine if a column exists through a SQL Statement...

With MySQL I would simply do: SHOW COLUMNS FROM `war3users` LIKE 'playerip'; Can I do something similar in SQLite ? Thanks!! Josh

Re: [sqlite] library routine called out of sequence

execute sqlite3 test.db < myscript from a bash shell. myscript creates a few tables. After running this, is my test.db in an open state, do I have to open test.db in my c program via sqlite3_open("test.db", &db_handle); John Stanton <[EMAIL PROTECTED]> wrote: Davide Berti wrote: > my typo her

Re: [sqlite] library routine called out of sequence

Davide Berti wrote: my typo here was the sqlite3_open call to open the database that is returning the error John Stanton <[EMAIL PROTECTED]> wrote: Davide Berti wrote: I am getting this error and have viewed the archives but am still at a loss. Can I load a script file that creates a view ta

Re: [sqlite] library routine called out of sequence

my typo here was the sqlite3_open call to open the database that is returning the error John Stanton <[EMAIL PROTECTED]> wrote: Davide Berti wrote: > I am getting this error and have viewed the archives but am still at a loss. > > Can I load a script file that creates a view tables: > > sqlite3

Re: [sqlite] library routine called out of sequence

Davide Berti wrote: I am getting this error and have viewed the archives but am still at a loss. Can I load a script file that creates a view tables: sqlite3 test.db < myscript then from a c program sd_open("test.db", db_handle); It keeps giving me the library routine error. My program is no

Re: [sqlite] How can I get the type of a column?

JP wrote: John Stanton wrote: I endorse Jay's approach. In our web page software using Sqlite everything is TEXT except for dates in Sqlite format. We use declared types to indicate classes of text, such as decimal numbers and dates. There are no radix conversion involved in data manipulati

Re: [sqlite] BLOB

[EMAIL PROTECTED] wrote: Hi (...at the first time... ;-) My App (up to 1500 Users, up to 15 Million Records in some tables in a SQL-Server-DB) offers as a specially feature Data-Export. The Export-Functionally is one of the most-used feature by Users. Exports are controlled and done by a Re

Re: [sqlite] Re: - Re: [sqlite] How can I get the type of a column?

The current API is complete regarding types. It returns both the declared type and the type actually stored. There is nothing else. Note that the actual storage type can vary between rows according to the data format, which is why the actual type is returned row by row. JS sqlite wrote: Jo

[sqlite] library routine called out of sequence

I am getting this error and have viewed the archives but am still at a loss. Can I load a script file that creates a view tables: sqlite3 test.db < myscript then from a c program sd_open("test.db", db_handle); It keeps giving me the library routine error. My program is not multi-threaded and

Re: [sqlite] Re: - Re: [sqlite] How can I get the type of a column?

Joe Wilson wrote: I also agree with Ralf's proposal for sqlite3_column_affinity(). (Not that a vote on this topic will likely make a difference. ;-) Another vote from me.

Re: [sqlite] How can I get the type of a column?

John Stanton wrote: I endorse Jay's approach. In our web page software using Sqlite everything is TEXT except for dates in Sqlite format. We use declared types to indicate classes of text, such as decimal numbers and dates. There are no radix conversion involved in data manipulation (apart fr

[sqlite] BLOB

Hi (...at the first time... ;-) My App (up to 1500 Users, up to 15 Million Records in some tables in a SQL-Server-DB) offers as a specially feature Data-Export. The Export-Functionally is one of the most-used feature by Users. Exports are controlled and done by a Report, controlled and done b

Re: [sqlite] Dumping Memory-DB to File

Hello everyone, thanks for your replies. I will try to speed things up by using transactions. Cheers + happy weekend, Henning -- View this message in context: http://www.nabble.com/Dumping-Memory-DB-to-File-t1592559.html#a4353870 Sent from the SQLite forum at Nabble.com.