[Gambas-user] make Label background from Database field
    Vassilis K 
    vkan53 at ...2300...
       
    Sun Oct 18 20:38:38 CEST 2009
    
    
  
After the function of change_bgcolor that existed and Benoit reminded us, the 
code is becoming more sophisticated: 
PUBLIC SUB Form_Open()
  DIM rsThesi AS Result
  DIM iTemp AS Integer
  DIM sTemp AS String
   MODMain.Connect()
   rsThesi = MODMain.$Con.exec("select * from egrafes where elenchosAnax = 0 
AND thesi <> 0 ")
   DO WHILE rsThesi.Index < rsThesi.Count - 1
        change_bgcolor("Label" & CInt(rsThesi!thesi))
        rsThesi.MoveNext()
   LOOP
END
SUB change_bgcolor(labelname AS String)
  Form1[labelName].Background = Color.Red
END
    
    
More information about the User
mailing list