<html><head></head><body><div class="ydpde282062yahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div></div>
<div>Thanks Bruce. I will give it a try!</div><div><br></div><div>Hi, Benoit. I have read the wiki, in fact, my browser currently opens on it. But Gambas/Ubuntu is not playing along. I don't know whether en_ZA.UTF-8 is not supported or badly supported but when gambas loads the date from the sqlite db it is loaded as mm/dd/yyyy hh:mm:ss before attempted conversion and mm/dd/yyyy after attempted conversion, and not as yyyy-mm-dd. My problem comes in with a user(s) having to update the database. It means we have to change the date back to sqlite3 format every time we update a record and with one record having four odd different dates that can become quite time consuming not to mention tedious. Every conversion so far I have attempted has resulted in Gambas literally 'arguing' and 'fixing' it for me...</div><div><br></div><div>I'm a newbie at Gambas having come from a QB/VB6 world to C and Max Reason's xbasic and Freebasic. Having to rewrite this in any of the latter would result in hours of coding which honestly I would rather avoid.</div><div><br></div><div>I am probably going to kick myself eventually for missing something small here but I think this is a good learning curve for me.</div><div><br></div><div>Regards</div><div><br></div><div>David</div><div><br></div>
</div></body></html>