Unknown record type:id--sqlite3/SQLdb under windows7

[Goodman H__]

Greetings!

I updated laz to the newest daily snapshot since it  supports unicode strings great.Here is my question:

I am still struggling to manipulate database with several db components provided by laz and also Zeos.I installed TSqlite3DataSet and Zeos both in my Laz.Below is my sqlite3 database DDL:

Code: [Select]

CREATE TABLE test(id small int primary key,name char(40),dateofbirth date);
This db works very well under windows7 both with TSqlite3DataSet and Zeso.But not [[TSQLite3Connection,TSQLTransaction,TSQLQuery]].In TSQLQuery,when I enter a basic sql statement like "select * from test" in the sql...(TStringList),it complains

Code: [Select]

Unknown record type:id

What does this mean?How can I fix it?

It would be grateful if anybody can help.

Regards,

[cdbc]

Hi.
Read the documentation for sqlite3 db...

Your DDL is incorrect:
  CREATE TABLE test(id small int primary key,name char(40),dateofbirth date);

Should be:
  CREATE TABLE test(id integer primary key,name char(40),dateofbirth date);

hth
Regards Benny

[Goodman H__]

Hi.
Read the documentation for sqlite3 db...

Your DDL is incorrect:
  CREATE TABLE test(id small int primary key,name char(40),dateofbirth date);

Should be:
  CREATE TABLE test(id integer primary key,name char(40),dateofbirth date);

hth
Regards Benny

Thank you so much!The subjected problem fixed though the dbgrid is still not usable with TSQLQuery under my system.

Regards,