Unknown record type:id--sqlite3/SQLdb under windows7
lazarus / 16-Databases

----------------------------------------------------------------------
Goodman H__ · 2010-08-13 00:46

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 · 2010-08-13 05:37

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__ · 2010-08-13 07:37

Quote from: cdbc on August 13, 2010, 07:37:15 amHi.
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,