Re: [sqlite] Adding colomns when the database/schema already exists

Are you trying to add a new column to your schema or to add a new row containing the column data from your message? JS [EMAIL PROTECTED] wrote: Hi, I'm developping an application that uses SQLite library. The application is server/clients concept, the server part manages the database. For

Re: [sqlite] Adding colomns when the database/schema already exists

On 5/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: <...>...<...>23 The 'Time' string represents a colomn in the database. If the database does not contains this colomn, I'd like to add it with default value, in this case, '0'. Or 'NULL' for strings. Is it possible to do something like

Re: [sqlite] Adding colomns when the database/schema already exists

Hi strafer, * [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2006-05-13 19:25]: > The 'Time' string represents a colomn in the database. If the > database does not contains this colomn, I'd like to add it with > default value, in this case, '0'. Or 'NULL' for strings. > > Is it possible to do something

[sqlite] Adding colomns when the database/schema already exists

Hi, I'm developping an application that uses SQLite library. The application is server/clients concept, the server part manages the database. For instance, the client sends a request to the server: <...>...<...>23 The 'Time' string represents a colomn in the database. If the database does not

Re: [sqlite] BLOB

Anne, People with English as a first language can have difficulty understanding the description of manifest typing in the Sqlite documenation. When you have less English it is more difficult :-). Sqlite returns the column name and type. Here is a code fragment which returns the column name

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

John, thank you very much for your answer. I'll study that possibility. So I would ask what's the exactly purpose of multi-thread support, but I can't, because I even hadn't read the whole documentation. Thanks again. Bye! On 5/13/06, John Stanton <[EMAIL PROTECTED]> wrote: Your problem is

Re: [sqlite] BLOB

Hi sqlite saya: (sorry... dont know, how to answer in thread) >Re: [sqlite] How can I get the type of a column? >sqlite >Thu, 11 May 2006 16:50:34 -0700 > > >Most SQL implementations use fixed-size records >so it makes more sense for them to enforce each >column's data type exactly - inserting

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

Hi John > 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.

Re: [sqlite] BLOB

Hi John Thanks for your answer... :-) > You could use CSV to go to Excel, SQL to Oracle etc. ..*snip* I do that all very succesful with ADO and OLE-DB... very rarely got problems. > If you don't want to use the Sqlite API then you have probably >chosen i want to use SQLite, because it's a

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

Your problem is not with threading, that seems to be working just fine, it is with the way Sqlite works. Since it is a single file it locks the entire file when you alter the DB so that only one thread/process can change it at a time. You need to rethink your application in such a way that