Function UpdatePilote (sidhard As String) As Integer
Dim Ret%
Dim sData$
UpdatePilote = False
'Trigger on update
sData = " UPDATE maitre.dbo.xmlpilote SET "
sData = sData + "Maj= '" + Date$ + "',"
sData = sData + "designation='" + TabSQLValue(0, 0) + "',"
sData = sData + "Name='" + TabSQLValue(0, 1) + "',"
sData = sData + "portname='" + TabSQLValue(0, 2) + "',"
sData = sData + "host='" + TabSQLValue(0, 3) + "',"
sData = sData + "port='" + TabSQLValue(0, 4) + "',"
sData = sData + "maxuser='" + TabSQLValue(0, 5) + "',"
sData = sData + "timeout='" + TabSQLValue(0, 6) + "',"
sData = sData + "directory='" + TabSQLValue(0, 7) + "',"
sData = sData + "filename='" + TabSQLValue(0, 8) + "',"
sData = sData + "content='" + TabSQLValue(0, 9) + "',"
sData = sData + "vspace='" + TabSQLValue(0, 10) + "',"
sData = sData + "hspace='" + TabSQLValue(0, 10) + "',"
sData = sData + "bookmark='" + TabSQLValue(0, 11) + "',"
sData = sData + "modedebug='" + TabSQLValue(0, 12) + "',"
sData = sData + "configcom='" + TabSQLValue(0, 13) + "',"
sData = sData + "enabled='" + TabSQLValue(0, 14) + "',"
sData = sData + "type ='" + TabSQLValue(0, 15) + "',"
sData = sData + "media ='" + TabSQLValue(0, 16) + "',"
sData = sData + "network ='" + TabSQLValue(0, 17) + "',"
sData = sData + "action ='" + TabSQLValue(0, 18) + "' "
sData = sData + " WHERE Id.xxKey=" + CStr(sidhard)
Ret = pExecute(sData)
If Ret = True Then
UpdatePilote = True
End If
End Function
|