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