field 'Time' in sqlite
lazarus / 16-Databases

----------------------------------------------------------------------
C#R# · 2007-01-27 02:07

Hello for All !

At a time ago I had to install laz9.16 over the laz9.20 because the
Date field in FIB dataset returns 00/00/000  .....

http://www.lazarus.freepascal.org/index.php?name=PNphpBB2&file=viewtop
ic&t=2922&highlight=date
http://www.lazarus.freepascal.org/index.php?name=PNphpBB2&file=viewtop
ic&t=3183&highlight=

well...
At this time, I work arround with laz9.20 and sqlite3.... and the
Code: [Select] PaintBox1.Canvas.TextOut(coluna -
30,10,TimeToStr(SqliteEvetosG.FieldByName('Hora').AsDateTime));

returns 00:00 ......  

But the
Code: [Select]PaintBox1.Canvas.TextOut(coluna -
30,10,DateToStr(SqliteEvetosG.FieldByName('Data').AsDateTime));
work´s good !!!

anybody know what is this ???  

thanks.....

----------------------------------------------------------------------
matthijs · 2007-01-27 11:17

Quote from: "C#R#"
anybody know what is this ???  

A bug?
Create a sample project. Call both functions for the same field. And
report it as bug in bug tracker. (Of course check first if it has not
been reported already.  )

----------------------------------------------------------------------
C#R# · 2007-01-28 00:51

Hi Matthijs,
Simply change to varchar is a good solution at this time ...(I don´t
have any data to save ... uuufffff!!!!)
Code: [Select]
form1.SqliteEventos.QuickQuery('insert into Eventos values (' +
QuotedStr(DateToStr(Now)) + ')' );
It is easy to retrieve too...
Code: [Select]PaintBox1.Canvas.TextOut(coluna -
30,5,SqliteEventos.FieldByName('Hora').AsString);

Thanks.