[Gambas-user] make Label background from Database field

[Doriano Blengino]

Vassilis K ha scritto:
> I have changed the Select of rsThesi to find only the records that thesi <> 0 
> as following:
> rsThesi = MODMain.$Con.exec("select * from egrafes where elenchosAnax = 0 
> AND thesi <> 0 ")
> Now it only counts 42 rows out of 70.
>
> But the error is the same as described in my previous email:
> "Result is not available"
> at line:
> "change_bgcolor("Label" & rsThesi!thesi)"
>   
Try to

    PRINT rsThesi!thesi
    PRINT "Label" & rsThesi!thesi

just before the line. I can not believe this... you can also try to use 
some intermediate temporary variable, like

    iTemp = rsThesi!thesi
    change_bgcolor("Label" & iTemp)

where iTemp is an integer local variable, or try the same but using a 
string sTemp.

Can't believe...

Regards,

-- 
Doriano Blengino

"Listen twice before you speak.
This is why we have two ears, but only one mouth."