Hi All
I have a sql statement which runs sans any issues in my sqlite viewer, but
when executed from within air it gives me the error
SQLError: 'Error #3132: Data type mismatch.', details:'could not convert
text value to numeric value.'
this is the table schema
CREATE TABLE category (
id bigint NOT NULL,
"version" integer NOT NULL,
name character varying(255),
ordering integer NOT NULL,
"external" boolean NOT NULL,
createddate timestamp without time zone,
modifieddate timestamp without time zone,
createdby_id bigint,
modifiedby_id bigint
);
and here is the sql statement
insert into category(id, version, name, ordering, external, createddate,
modifieddate, createdby_id, modifiedby_id) values
(477,14,'Leads',0,'false',NULL,'2008-08-19 16:46:54.26',NULL,1109);
any ideas?
i find it really weird that this works on a SQLite level, but not from AS.
johan
--
j:pn
\\no comment
