<html><head></head><body><div class="ydp3c4d6675yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">HI Gianluigi</div><div dir="ltr" data-setdir="false">Lee's statement was directed at me using a textbox for dates. It actually works for me except when I try and retrieve a date from the SQLite database. </div><div dir="ltr" data-setdir="false">I'm beginning to suspect that if I do not create the DB in Gambas then it is difficult to get it to work. My current database is ten years old and has 200k entries +. I originally created it in xbasic in 2008/2009 and even after using a datebox Gambas still doesn't read the date properly. However, if I create a new DB in Gambas and do all these things it works without a hitch. </div><div dir="ltr" data-setdir="false">It doesn't make sense to me though since the date portion of the database in sqlite3 is still DATE and referred to as such in the DB. When I create the new DB using Gambas it just works, whether I load or retrieve, but when I go to my old DB then all the dates go awry. I'm definitely going to need some time to work through this.</div><div dir="ltr" data-setdir="false">Thanks for that datadate source. It's helped a lot, AND also for helping me get the datebox back. Much appreciated.</div><div><br></div>
</div><div id="yahoo_quoted_5561525611" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, November 25, 2019, 06:31:08 PM GMT+2, Gianluigi <bagonergi@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv2897492246"><div><div dir="ltr"><div dir="ltr"><br clear="none"></div><br clear="none"><div class="yiv2897492246gmail_quote"><div class="yiv2897492246yqt0217421458" id="yiv2897492246yqtfd60049"><div class="yiv2897492246gmail_attr" dir="ltr">Il giorno lun 25 nov 2019 alle ore 16:30 T Lee Davidson <<a rel="nofollow" shape="rect" ymailto="mailto:t.lee.davidson@gmail.com" target="_blank" href="mailto:t.lee.davidson@gmail.com">t.lee.davidson@gmail.com</a>> ha scritto:<br clear="none"></div></div><blockquote class="yiv2897492246gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div class="yiv2897492246yqt0217421458" id="yiv2897492246yqtfd96707">SQLite can store dates as one of three different types: text, real, or integer.<br clear="none">
<br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://www.sqlite.org/datatype3.html">https://www.sqlite.org/datatype3.html</a><br clear="none">
<br clear="none">
<br clear="none">
___<br clear="none">
Lee</div><br clear="none">
<br clear="none"></blockquote><div><br clear="none"></div><div><br clear="none"></div><div>I refer to Gambas not to SQLite.<br clear="none">See what Benoit says about it:<br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://gambaswiki.org/wiki/doc/date">http://gambaswiki.org/wiki/doc/date</a><br clear="none">See also:<br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://gambaswiki.org/wiki/doc/db-type-mapping">http://gambaswiki.org/wiki/doc/db-type-mapping</a><br clear="none"><br clear="none">Regards<br clear="none">Gianluigi <div class="yiv2897492246yqt0217421458" id="yiv2897492246yqtfd99455"><br clear="none"></div></div></div></div></div></div><div class="yqt0217421458" id="yqtfd87391"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net " target="_blank">https://www.hostsharing.net </a>]----<br clear="none"></div></div>
</div>
</div></body></html>