Function InsertProgramme (Id As Integer) As Integer
Dim Ret%
Dim sData$
Dim s$
Dim screa$
Dim sidProg$
InsertProgramme = False
Ret = pExecute("CLEAR")
sData = " INSERT INTO Programme (CodeEnseigne,Creation,maj,Name,DebutValidite,FinValidite, "
sData = sData + " burnpoint,burnlabpoint,burnvaleur,minburnresi, "
sData = sData + " eurnpoint,eurnlabpoint,eurnvaleur,mineurnresi, "
sData = sData + " isburnresi,iseurnresi,type,modeburn,relation,modeeurn,uniteburn,uniteeurn) VALUES ( "
sData = sData + "'" + TabSQLValue(0, 0) + "',"
screa = Date$
sData = sData + "'" + screa + "',"
sData = sData + "'" + screa + "',"
sData = sData + " '" + TabSQLValue(0, 1) + "',"
sData = sData + " '" + TabSQLValue(0, 2) + "',"
sData = sData + " '" + TabSQLValue(0, 3) + "',"
sData = sData + " '" + TabSQLValue(0, 4) + "',"
sData = sData + " '" + TabSQLValue(0, 5) + "',"
sData = sData + " '" + TabSQLValue(0, 6) + "',"
sData = sData + " '" + TabSQLValue(0, 7) + "',"
sData = sData + " '" + TabSQLValue(0, 8) + "',"
sData = sData + " '" + TabSQLValue(0, 9) + "',"
sData = sData + " '" + TabSQLValue(0, 10) + "',"
sData = sData + " '" + TabSQLValue(0, 11) + "',"
sData = sData + " '" + TabSQLValue(0, 12) + "',"
sData = sData + " '" + TabSQLValue(0, 13) + "',"
sData = sData + " '" + TabSQLValue(0, 14) + "',"
sData = sData + " '" + TabSQLValue(0, 15) + "',"
sData = sData + " '" + TabSQLValue(0, 16) + "',"
sData = sData + " '" + TabSQLValue(0, 17) + "',"
sData = sData + " '" + TabSQLValue(0, 18) + "',"
sData = sData + " '" + TabSQLValue(0, 19) + "') "
Ret = pExecute(sData)
If Ret = True Then
Ret = XasUserGetString(1, sidProg)
s = TabSQLValue(0, 14)
Ret = ProgrammeForINSERT(Val(s), sidProg)
If Ret = True Then
InsertProgramme = True
End If
End If
End Function
|