Dear Doriano, I have tested both codes with
sTemp = CStr(rsThesi!thesi) 'As a string variable AND then with iTemp = rsThesi!thesi 'As Integer I get the results on the console but the code now stops at: sTemp = CStr(rsThesi!thesi) OR at iTemp = rsThesi!thesi with message "Result is not available" When the code stops the variable sTemp has the last value of the field. (I can see the results on the console with the line that you suggested: PRINT "Record: " & CStr(rsThesi.Index) & " Result: " & CStr(rsThesi!thesi)) The results are the following: Record: 0 Result: 2 Record: 1 Result: 12 Record: 2 Result: 57 Record: 3 Result: 56 Record: 4 Result: 44 Record: 5 Result: 11 Record: 6 Result: 78 Record: 7 Result: 3 Record: 8 Result: 89 Record: 9 Result: 23 Record: 10 Result: 67 Record: 11 Result: 33 Record: 12 Result: 34 Record: 13 Result: 34 Record: 14 Result: 78 Record: 15 Result: 34 Record: 16 Result: 2 Record: 17 Result: 1 Record: 18 Result: 32 Record: 19 Result: 43 Record: 20 Result: 12 Record: 21 Result: 3 Record: 22 Result: 1 Record: 23 Result: 1 Record: 24 Result: 1 Record: 25 Result: 12 Record: 26 Result: 1 Record: 27 Result: 23 Record: 28 Result: 23 Record: 29 Result: 34 Record: 30 Result: 34 Record: 31 Result: 56 Record: 32 Result: 1 Record: 33 Result: 56 Record: 34 Result: 89 Record: 35 Result: 12 Record: 36 Result: 4 Record: 37 Result: 1 Record: 38 Result: 3 Record: 39 Result: 34 Record: 40 Result: 12 Record: 41 Result: 1 Record: 42 Result: 2 Record: 43 Result: 3 ------------------------------------------------------------------------------ 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