SQLite3 and problem with date in TdbGrid
lazarus / 16-Databases

----------------------------------------------------------------------
PetrHH · 2007-05-30 08:25

Good morning,

I use TSqlite3Dataset connected to DataSouce and TDbGrid. I have
simple table created by SQL := 'CREATE TABLE test (mydate DATE)';

I tried to save record using SQL := 'INSERT INTO test (mydate) VALUES
('2007-05-30')';

In Tdbgrid are empty records. If I open the database in SQliteExprert,
records are correct. If I insert record using INSERT INTO test
(mydate) VALUES (2007-05-30), in Tdbgrid is date 25.1.1905.

The same problem is in Linux. Lazarus is last daily snapshot and fpc
2.0.4.


Could you help me, please?

Thanks!


Petr

----------------------------------------------------------------------
PetrHH · 2007-05-30 10:50

The same problem is also without Lazarus. In fpc program
Q.FieldByName('mydate').AsDateTime returns null, too. It looks like an
error in fpc. I'll try fpc 2.1.5.

Anybohy know what is wrong?

Thnaks for help.

Petr

----------------------------------------------------------------------
PetrHH · 2007-05-31 11:14

Version 2.1.5 has the same problem. Could anyone report this to
bugzilla? I don't know how to do it and where. Thanks.

Petr

----------------------------------------------------------------------
Marc · 2007-05-31 14:26

See the bugtracker link in the mainmenu, topleft of this page

----------------------------------------------------------------------
LuizAmérico · 2007-06-11 00:24

See http://www.lazarus.freepascal.org/index.php?name=PNphpBB2&file=vie
wtopic&t=1704 and you will understand the problem and find a solution.