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

2006-05-14 Thread strafer
Selon John Stanton <[EMAIL PROTECTED]>: > Are you trying to add a new column to your schema or to add a new row > containing the column data from your message? Trying to add a new column to the DB if it doen't exist and then, insert values. -- Delf

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

2006-05-13 Thread John Stanton
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 ins

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

2006-05-13 Thread Nemanja Corlija
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 tha

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

2006-05-13 Thread A. Pagaltzis
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 l

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

2006-05-13 Thread strafer
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