[sqlite] Select via Wi-fi very slow

00;" My select: "SELECT codigo, description FROM Product WHERE description Like '" & Word _Search & "%'" Thanks, Ernany ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Vaccum with VB,NET

Hello guys, How i run sqllite with VB2005 , NE|T. I need tio run *"Vacuum"*. Thanks a lot Ernany ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL sintaxe

Hello John, I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application "MARCA" and "DESCR". This code is VB2005 .NET. How do I write SQL??? Thanks a lot Ernany '*** Dim

[sqlite] SQL sintaxe

r*". select SUM(qtde) AS cont, descr , codigo FROM pcdesc GROUP BY codigo, descr ? Wrong. Thanks a lot, Ernany ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite + CrystalReport + Visual Basic . NET

Hello, Is it possible to use CystalReport + SQLite with Visual Basic 2005. NET?? Thanks, Ernany ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] UPDATE - to simplify the code...

untry] NVARCHAR(1), [Bem] NUMERIC(9) NOT NULL ON CONFLICT ROLLBACK PRIMARY KEY ON CONFLICT ROLLBACK, [Status] NVARCHAR(1), [Responsavel] NVARCHAR(10)); ****

Re: [sqlite] Error message "database disk image is malformed"

Thanks, Ernany 2008/11/17 Joanne Pham <[EMAIL PROTECTED]> > Hi All, > Suddenly on my server whenever I login to the database using the following > command: > sqlite3 myDB > and > run the .schema I got the error message return back: > "Error: database disk image is m

[sqlite] Problem : "The database disk image is malformed"

Thanks, Ernany ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] UPDATE - to simplify the code...

Hello , Is it possible to simplify the code? I have ten fields to UPDATE. (STATUS, Responsavel, Country,..) Thanks, Ernany ** UPDATE Bens SET *STATUS *= CASE (SELECT COUNT

[sqlite] Update is it correct???

= (SELECT NewPROD.qtde FROM NewProd WHERE NewPROD.codigo = PROD.codigo) Is it POSSIBLE?? table : PROD codigo descriçao qtde 1 banana 10 2 abacaxi 20 3 nada 10 4 tudo 20 5 cinco 30 6 seis 60 7 sete 70 8 oito 80 Thanks a lot, Ernany D