Hey MSulchan, if you're trying to convert either "x", "-", or NULL to an integer you're correctly going to get a mismatch error
basically the mismatch error is a way of saying "I can't convert "x" into an integer, I don't know what number to convert "x" to" what I would personally use instead of iRain = CInt(sRain) is a Select statement like this one SELECT CASE sRain Case "0" iRain = 0 Case "1" iRain = 1 Case "2" iRain = 2 Case "x" iRain = 3 Case "-" iRain = 4 Case ELSE 'this case would be used in case of anything else including null iRain = -1 END SELECT this way iRain would always have an integer and you wouldn't have to worry about the mismatch error... assuming "0", "1", "2", "x", "-" and NULL are the only values used in your database. I hope this helps Regards Dimitris On Mon, Aug 24, 2009 at 10:35 PM, MSulchan Darmawan <bleke...@gmail.com>wrote: > Dear sir, > > I have the following code : > > DIM sRain AS String > DIM iRain AS Integer > DIM iPos AS Integer > DIM iYear AS String > DIM iMonth AS String > > modMain.Connect > hRes = modMain.$Con.Exec("SELECT * FROM table") > > FOR EACH hRes > > iPos = hRes!id > iYear = hRes!yr > iMonth = hRes!mn > sRain = hRes!r1 > > ' PRINT iPos, iYear, iMonth, sRain > iRain = CInt(sRain) > IF iRain > 100 THEN PRINT iPos, iYear, iMonth > > NEXT > > on this line : iRain = CInt(sRain) > I got the type mismatch error. > This is my first try to program on gambas. > So why the error happened ? Any suggestion to fix are welcome. > > FYI, the database connected successfully, hRes!r1 is a string, sRain is > a string, and I'd like to get the integer value of sRain. > The possible value of sRain is : "0", "1", "2", "x", "-", NULL. > > Help ! > I'm using gambas2 2.8.2 on linux mint 7. > > Thanks in advance. > Regards, > Sulchan > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus > on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user