I have a gridview control and i fill it with values from a mysql $RESULT with the next code
PUBLIC SUB grdView_Data(Row AS Integer, Column AS Integer) $Result.MoveTo(Row) grdView.Data.Text = Str($Result[grdView.Columns[Column].Text]) END The problem now. When value is Date with mysql format %Y-%m-%d the gridview shows "00:00:00" instead "0000:00:00" when the value of result is empty and change the format to %m/%d/%Y. For example see col4 which holds dates mysql> SELECT * FROM `table4`; +------+------+------+------------+ | col1 | col2 | col3 | col4 | +------+------+------+------------+ | 1 | 11 | 111 | 2008-09-24 | <- %Y-%m-%d | 2 | 22 | 222 | 0000-00-00 | +------+------+------+------------+ 2 rows in set (0.00 sec) And gridview shows 09/24/08 Why is this? Normally the gridview must get the string " 2008-09-24" -- Γεια χαρα σε όλους!!! Regards, Demosthenes Koptsis ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user