Function PUSHSETCombo (iType As Integer) As Integer
Dim Ret%
Dim sData$
Dim iIndice%
Dim i%
Ret = XasUserSetProperties(FrmMain.TxDesi, 181, 6)
For i = 0 To 5
FrmMain.cb(i).Clear
Ret = XasUserSetProperties(FrmMain.cb(i), 181, 2)
Ret = XasUserSetProperties(FrmMain.cb(i), 48, "")
Ret = XasUserSetProperties(FrmMain.cb(i), 49, "")
Ret = XasUserSetProperties(FrmMain.cb(i), 17, "")
Ret = XasUserSetProperties(FrmMain.cb(i), 90, "")
Ret = XasUserSetProperties(FrmMain.cb(i), 146, "subactivlabel")
Next i
sData = "SELECT TOP 300 designation,CodeClient From Client WHERE type.integer=10 "
Ret = XasUserSQLtoCtrl(1, TmpRowSet, GlobCurService + ".FrmMain.cbr(0)", sData, GlobCurFileDom)
sData = "SELECT Name,CodeProgramme From Programme WHERE type.integer=10 "
Ret = XasUserSQLtoCtrl(1, TmpRowSet, GlobCurService + ".FrmMain.cbr(1)", sData, GlobCurFileDom)
sData = "SELECT name,id From @@XasUserPays.typepush WHERE id.integer != 0 "
Ret = XasUserSQLtoCtrl(1, TmpRowSet, GlobCurService + ".FrmMain.cb(0)", sData, GlobCurFileDom)
Ret = XasUserSQLtoCtrl(1, TmpRowSet, GlobCurService + ".FrmMain.cbr(2)", sData, GlobCurFileDom)
End Function
|