[Gambas-user] make Label background from Database field

Vassilis K vkan53 at ...2300...
Sun Oct 18 10:15:12 CEST 2009


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





More information about the User mailing list