[Gambas-user] make Label background from Database field

[Vassilis K]

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