[sqlite] SQLite.exe for windows 98

2009-04-14 Thread REPKA_Maxime_NeufBox
Hello, The last version of Sqlite.exe is not working with Windows 98 Where can I find the last version of Sqlite.exe compatible for windows 98 ? Thank's MaxMax14 ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Select table name and count(*) on same command

2009-03-26 Thread REPKA_Maxime_NeufBox
Hello, Exemple of 2 SQL command : sqlite> select name from sqlite_master where type='table'; City Country CountryLanguage sqlite_stat1 sqlite> select count(*) from country; 239 ->> Could anyone tell me what is the command to get the following result : Table names

[sqlite] SQLITE : Constraint question

2009-03-11 Thread REPKA_Maxime_NeufBox
Hello, I am working on Database not for a long time. From SQLITE Tutorial exam table :* ->> Why is it possible to change data not defined in the constraint : Exemple : enter TEXT if the column is INTERGER ?? enter 25 caracters if column is declared VARCHAR(15) ?? I thought i will

Re: [sqlite] SAVEPOINT : Seems don't work : SOLVED (version problem)

2009-02-25 Thread REPKA_Maxime_NeufBox
Discussion of SQLite Database Objet : Re: [sqlite] SAVEPOINT : Seems don't work On Feb 25, 2009, at 2:31 AM, REPKA_Maxime_NeufBox wrote: > I try for test as follow : > > on DOS : sqlite3.exe Database > > then type : SAVEPOINT spoint; > Error message is : 'SQL error :near "s

Re: [sqlite] SAVEPOINT : Seems don't work

2009-02-24 Thread REPKA_Maxime_NeufBox
ith Begin, commit and rollback -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]de la part de Dan Envoye : mardi 24 fevrier 2009 05:23 A : General Discussion of SQLite Database Objet : Re: [sqlite] SAVEPOINT : Seems don't work On Feb 24, 2009, at

[sqlite] SAVEPOINT : Seems don't work

2009-02-23 Thread REPKA_Maxime_NeufBox
Hello, I am quite new to use SQLite I tried to use SAVEPOINT command but didn't succeed Does this command work ? how ? MaxMax14 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users