I tested : PRINT CStr(rsThesi!thesi) PRINT CStr(rsThesi.Index)
Instead of change_bgcolor("Label" & rsThesi!thesi)" and I got everything working fine !!!! I got 42 couples of numbers as it should be: 38 0 15 1 47 2 74 3 96 4 etc... up to 42 row !! the first number was the correct rsThesi!thesi and the second number was the Index. I controlled the data of MySQL from phpMyAdmin and it is the same!! (where elenchosAnax = 0 AND thesi <> 0) AFter the print of the numbers as described above, the code stops and I get my well known message: "Result is not available" at line PRINT CStr(rsThesi!thesi) Strange? ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) 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/devconference _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user