Function InsertScenario (sidProg As String) As Integer
Dim Ret%
Dim sData$
Dim screa$
Dim sidScenar$
screa = Date$
Ret = pExecute("CLEAR")
Ret = pExecute("Select CodeProgramme From Programme Where CodeProgramme.xxKey = " + CStr(sidProg))
If (Ret = True) Then
sData = " INSERT INTO Programme.Scenario (Creation,maj,Name,CodeProgramme,debutvalidite,heuredebut,finvalidite,heurefin,point,burnpoint,burnlabpoint,"
sData = sData + " burnvaleur,burnaddpoint,valuea,valueb,article,modepassage,modesite,mediarules,"
sData = sData + " Type,uniteburn,codesite,entity,critentity,operateur,criterea,critereb,modeledocid,FileType,"
sData = sData + " Traitement,Icon,ForeColor,isstate,typealerteid,Sorted) VALUES ("
sData = sData + "'" + screa + "',"
sData = sData + "'" + screa + "',"
sData = sData + " '" + TabSQLValue(0, 0) + "',"
sData = sData + " '" + CStr(sidProg) + "',"
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) + "',"
sData = sData + " '" + TabSQLValue(0, 20) + "',"
sData = sData + " '" + TabSQLValue(0, 21) + "',"
sData = sData + " '" + TabSQLValue(0, 22) + "',"
sData = sData + " '" + TabSQLValue(0, 23) + "',"
sData = sData + " '" + TabSQLValue(0, 24) + "',"
sData = sData + " '" + TabSQLValue(0, 25) + "',"
sData = sData + " '" + TabSQLValue(0, 26) + "', "
sData = sData + " '" + TabSQLValue(0, 27) + "', "
sData = sData + " '" + TabSQLValue(0, 28) + "', "
sData = sData + " '" + TabSQLValue(0, 29) + "', "
sData = sData + " '" + TabSQLValue(0, 30) + "',"
sData = sData + " '" + TabSQLValue(0, 31) + "' ) "
Ret = pExecute(sData)
If Ret = True Then
Ret = XasUserGetString(1, sidScenar)
If Ret Then
InsertScenario = True
End If
End If
End If
End Function
|