XAS, Xml Server, Xml Services, XML Kiosk, Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)

Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)

Technologie	XAS.Technology	Version	V 6.0.1
Dernière modification	Samedi 28 Août 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Mercredi 8 Septembre 2010	Par	Support France
Thème	Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.UpdateHardWare

Prototype

Function UpdateHardWare (sidhard As String) As Integer

Usage
Administration-des-lots-de-cartes.UpdateHardWare(...)
HTTP (GET,POST)	SOAP WSDL	SOAP REST	XML-RPC

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function UpdateHardWare (sidhard As String) As Integer

Function UpdateHardWare (sidhard As String) As Integer
Dim Ret%
Dim sData$

UpdateHardWare = False
'Trigger on update

sData = " UPDATE HardWare SET "
sData = sData + "Maj= '" + Date$ + "',"
sData = sData + "Name='" + TabSQLValue(0, 0) + "',"
sData = sData + "numCompta='" + TabSQLValue(0, 1) + "',"
sData = sData + "NumSerie='" + TabSQLValue(0, 2) + "',"
sData = sData + "NumMaitre='" + TabSQLValue(0, 3) + "',"
sData = sData + "NumAgent='" + TabSQLValue(0, 4) + "',"

sData = sData + "IsDisabled='" + TabSQLValue(0, 5) + "',"
sData = sData + "IsCaptif='" + TabSQLValue(0, 6) + "',"

sData = sData + "OSVersion='" + TabSQLValue(0, 7) + "',"
sData = sData + "memorysize='" + TabSQLValue(0, 8) + "',"
sData = sData + "AdresseIp='" + TabSQLValue(0, 9) + "',"

sData = sData + "numpad='" + TabSQLValue(0, 10) + "',"
sData = sData + "numhost='" + TabSQLValue(0, 11) + "',"
sData = sData + "hostdata='" + TabSQLValue(0, 12) + "',"
sData = sData + "hostkey='" + TabSQLValue(0, 13) + "',"

sData = sData + "hostheure='" + TabSQLValue(0, 14) + "',"
sData = sData + "hostappel='" + TabSQLValue(0, 15) + "',"

sData = sData + "type ='" + TabSQLValue(0, 16) + "',"
sData = sData + "hardmode ='" + TabSQLValue(0, 17) + "',"
sData = sData + "hardreseau ='" + TabSQLValue(0, 18) + "',"
sData = sData + "position ='" + TabSQLValue(0, 19) + "',"
sData = sData + "idhardassoc ='" + TabSQLValue(0, 20) + "',"
sData = sData + "onprog ='" + TabSQLValue(0, 21) + "',"
sData = sData + "onpv='" + TabSQLValue(0, 22) + "' "
sData = sData + " WHERE Id.xxKey=" + CStr(sidhard)
Ret = pExecute(sData)
If Ret = True Then
    UpdateHardWare = True
End If

End Function

Références XAS.Technology

Date , Cstr ,

Audience

Cette documentation est destinée aux personnes s'intéressant aux systèmes d'information collaboratifs.
Les Webservices, les architectures collabortives et distribuées, les moteurs transactionnelles et les concepts de programmation orientés objet.