Re: [sqlite] How to add a table ?

2006-06-14 Thread Thierry Nauze


Le 14 juin 06 à 18:33, Eduardo a écrit :


At 04:56 14/06/2006, you wrote:

Hello,

I have a database.

I want to add a table with columns
id integer
name varchar
addresse varchar
...

Which instructions (exactly) I have to give.


Check this page http://www.sqlite.org/sqlite.html , there are the  
basic SQL commands for manage a database, including create table.


Thank you, I have already had solution.

It was a question of adding a table to an existing base.
I did not think that it was the same command that for a creation.

Simple and efficient !


--
Thierry NAUZESaint-Denis de la Réunion




[sqlite] How to add a table ?

2006-06-13 Thread Thierry Nauze

Hello,

I have a database.

I want to add a table with columns
id integer
name varchar
addresse varchar
...

Which instructions (exactly) I have to give.

I work with REALBASIC 2006 on Mac

Thank you


--
Thierry NAUZESaint-Denis de la Réunion




Re: [sqlite] Problems with character '

2006-02-28 Thread Thierry Nauze


Le 28 févr. 06 à 14:25, Niels Boldt a écrit :


Hi Guys

I'm having some problems dealing with the character '. Sqlite thinks
fair enough that it should terminate the string, which I would like it
to avoid. Are there any solutions to my problems.

Thanks, Niels


Replace the   '  (one ' ) with  ''   (two ')

Regards,

--
Thierry NauzeSaint-Denis de la Réunion
Who don't speak English;o)