Function InsertHardWare (IdSite As String) As Integer
Dim Ret%
Dim sData$
InsertHardWare = False
Ret = pExecute("CLEAR")
Ret = pExecute("Select CodeSite From Site Where CodeSite.xxKey = " + CStr(IdSite))
If (Ret = True) Then
sData = " INSERT INTO Site.HardWare (Creation,maj,Name,numCompta,NumSerie,NumMaitre,NumAgent,OSVersion,memorysize,AdresseIp,"
sData = sData + " numpad,numhost,hostdata,hostkey,hostheure,hostappel,type,hardmode,hardreseau,position,idhardassoc,onprog,onpv,iscaptif) VALUES ("
sData = sData + "'" + Date$ + "',"
sData = sData + "'" + Date$ + "',"
sData = sData + " '" + TabSQLValue(0, 0) + "',"
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) + "' ) "
Ret = pExecute(sData)
If Ret = True Then 'type hardware
Ret = HardwareForINSERT(Val(TabSQLValue(0, 14)))
If Ret Then
InsertHardWare = True
End If
End If
End If
End Function
|