ok i got it. Thanks!
2009/9/18 Benoît Minisini <gam...@users.sourceforge.net>: >> 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" >> > > No. Gambas takes from MySQL the real date, and then you convert it to a string > with the Str() function. The "mysql" program does the same thing, but uses its > own "date to string" conversion functions. > > If you want the same format, instead of using Str() (which is the better IMHO, > as it follows the system localization settings), do that: > > grdView.Data.Text = Format($Result[grdView.Columns[Column].Text], > "yyyy-mm-dd") > > Regards, > > -- > Benoît Minisini > > ------------------------------------------------------------------------------ > 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 > -- Γεια χαρα σε όλους!!! 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
