Re: [sqlite] What is the best way to connect to SQLite from VB/VBA?

2006-11-13 Thread Carlos Avogaro
With the odbc driver, is ease and faster RB Smissaert <[EMAIL PROTECTED]> wrote: Have spent 2 days looking at all the different wrappers and the one ODBC driver and maybe the best one is the commercial dll from Terra... Still, I would be very interested what opinions are about the best (speed,

[sqlite] problem with sqlite3 in lazarus

2006-10-19 Thread Carlos Avogaro
Hi, I have sqLite version 3.3.6, and I'm using with lazarus in windows. With sqlite3.exe, I created this table create table product (cod varchar(6), ean varchar(13), desc varchar(30), pvp numeric(10,2)) from lazarus I did 4000 insert, like this: insert into product values