Re: [sqlite] SQLite or MS Access

have you try this on usb key ? i've very bad benchmark on this, try in hard disk in this case Sylko Zschiedrich a écrit : Do all insert's in one transaction and it will be done in 1 second or less. Begin transaction 1..1000 insert into table Commit transaction Ciao Sylko

Re: [sqlite] Open SQLite database from VB

search finisar sqlite on google you will find a wrapper :o) cstrader232 a écrit : Hello, I'm using Visual Basic Express for the first time. I'd like to connect from VB to my sqlite database. I figured that the database would show up in the databases list as it does in Excel but it does not

Re: [sqlite] SQLite 3 and MS SQL CE Compatibility Issues?

Many differents on create table statements... [EMAIL PROTECTED] a écrit : My client has an application which uses MS-SQL CE. My app uses SQLite 3. Does anyone know of any compatibility issues? Thanks, Richard

Re: [sqlite] sqlite DB on a CD

if your databse was not bigger you can put your sql dump in the zip and construct a memory database with this dump - Original Message - From: "Lauri Ojansivu" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" Sent: Wednesday, April 23, 2008 12:12

Re: [sqlite] qualified names in WHERE clause

try SELECT Test2.* FROM test2 inner join test11 ON test2.id=test11.id ORDER By Name; Will Leshner a écrit : I guess I never really noticed this before (since I only use SQLite, of course :) ). But consider a query like this: SELECT test2.* FROM test2,test11 WHERE test2.id=test11.id ORDER

[sqlite] VB6 question

oto.db" sqlite3_open sFilename, lDbHandle MsgBox ("lRet=" & lRet) MsgBox ("ldbhandle=" & lDbHandle) sqlite3_close (lDbHandle) End Sub when i launch it, i've an error 49 : Bad DLL calling convention anyone can help me ? where is my fault ? thx Gregory Letellier

Re: AW: [sqlite] VB6 question

sqlite3_close (lDbHandle) End Sub when i launch it, i've an error 49 : Bad DLL calling convention anyone can help me ? where is my fault ? thx Gregory Letellier

Re: AW: [sqlite] VB6 question

PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Gregory Letellier Sent: 27 July 2005 11:17 To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] VB6 question Ok Thank's for your help i will trying this !!! [EMAIL PROTECTED] a écrit : Hi, unfortunately this has to do with the C calling

Re: [sqlite] sqlite with visual basic?

use ags sqlite wrapper it works fine with .net Scott Chapman a écrit : I am having a look at Visual Basic Express 2005 Beta. I haven't programmed VB since version 3.0 on Windows 3.1 many years ago. I didn't do any database with it then. All of my programming these days is in Python with

Re: [sqlite] Dotnet C# support

i'm trying tu use sqli3 with vb. net he create the db but not the table.. what is the mistake ? i've this code Imports System.Runtime.InteropServices Public Class Form1 _ Public Structure sqlite_callback

Re: [sqlite] Dotnet C# support

thx for your response !! Robert Simpson a écrit : - Original Message - From: "Gregory Letellier" <[EMAIL PROTECTED]> i'm trying tu use sqli3 with vb. net he create the db but not the table.. what is the mistake ? i've this code Imports System.Runtime.Interop

[sqlite] single quote protection

hello,   i've many strings value to insert in a varchar column, but this strings contains character : '   how to protect it ?   thx for your help !       IncrediMail - La messagerie électronique a enfin évolué - Cliquer

[sqlite] Réf. : Re: [sqlite] single quote protection

 thx for your help     ---Message original---   De : Tito Ciuro Date : 04/01/04 14:24:31 A : Gregory Letellier Cc : [EMAIL PROTECTED] Sujet : Re: [sqlite] single quote protection   Hello Gregory,   http://www.mail-archive.com/[EMAIL PROTECTED]/msg01031.html   Advice: use

[sqlite] SQLite and PHP 4.3 in windows

hello i want to use php_sqlite.dll in php 4.3, i make this : - i'm working in Win XP pro with IIS - put the php_sqlite.dll in c:\php - edit the php.ini, i change the "extension_dir" to c:\php - restart the iis but when i load a page with sqlite i've an error can load module php_sqlite.dll...

Re: [sqlite] VACUUM question

VACUUM was the function for remove unused space in file after many operation on this, delete,update,etc i think it is that [EMAIL PROTECTED] a écrit : My understanding is that a stupid question is the one not asked. Excuse my ignorance, but what is VACUUM? I've seen a couple of e-mails go