Function UpdateProgramme (sidProg As String) As Integer
Dim Ret%
Dim sData$
UpdateProgramme = False
'ret=ProgrammeForUPDATE(idProg)
'If ret = True Then
'Else
' Exit Function
'End If
sData = " UPDATE Programme SET "
sData = sData + "Maj= '" + Date$ + "',"
sData = sData + "Name='" + TabSQLValue(0, 0) + "',"
sData = sData + "DebutValidite='" + TabSQLValue(0, 1) + "',"
sData = sData + "FinValidite='" + TabSQLValue(0, 2) + "',"
sData = sData + "burnpoint='" + TabSQLValue(0, 3) + "',"
sData = sData + "burnlabpoint='" + TabSQLValue(0, 4) + "',"
sData = sData + "burnvaleur='" + TabSQLValue(0, 5) + "',"
sData = sData + "minburnresi='" + TabSQLValue(0, 6) + "',"
sData = sData + "eurnpoint='" + TabSQLValue(0, 7) + "',"
sData = sData + "eurnlabpoint='" + TabSQLValue(0, 8) + "',"
sData = sData + "eurnvaleur='" + TabSQLValue(0, 9) + "',"
sData = sData + "mineurnresi='" + TabSQLValue(0, 10) + "',"
sData = sData + "isburnresi='" + TabSQLValue(0, 11) + "',"
sData = sData + "iseurnresi='" + TabSQLValue(0, 12) + "',"
sData = sData + "Type ='" + TabSQLValue(0, 13) + "',"
sData = sData + "modeburn ='" + TabSQLValue(0, 14) + "',"
sData = sData + "relation ='" + TabSQLValue(0, 15) + "',"
sData = sData + "modeeurn ='" + TabSQLValue(0, 16) + "',"
sData = sData + "uniteburn ='" + TabSQLValue(0, 17) + "',"
sData = sData + "uniteeurn ='" + TabSQLValue(0, 18) + "' "
sData = sData + "codeEnseigne ='" + TabSQLValue(0, 19) + "' "
sData = sData + " WHERE CodeProgramme.xxKey=" + CStr(sidProg)
Ret = pExecute(sData)
If Ret = True Then
UpdateProgramme = True
End If
End Function
|