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

[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,
ease of use, so methods etc. close to ADO) way to connect.
This is from VB6/VBA. The database I am working with is Interbase 5.6 and
I will have to move data from IB to SQLite.

RBS



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



 
-
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.

[sqlite] problem with sqlite3 in lazarus

[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 ('0001','12312345','test test tes', 4500.34)
   
  then I check the result with sqlite3.exe and everything is ok!
   
  but when I open a recorsed SELECT * FROM PRODUCT from lazarus I received this 
messages, FIELD TYPE VARCHAR(6) NOT RECOGNIZED.
   
  then I created the table in this way:
   
  create table product (cod varchar, ean varchar, 
  desc varchar, pvp numeric(10,2))
   
  and when I open the recorsed SELECT * FROM PRODUCT from lazarus I received 
this messages, FIELD TYPE NUMERIC(10,2) NOT RECOGNIZED.
   
  Please help me, I need to finish my proyect.
  Thank you


-
Get your email and more, right on the  new Yahoo.com