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

Administration des comptes, (Web, Web Services, PDA, WidGet, Fat Client)

Technologie	XAS.Technology	Version	V 6.0.1
Dernière modification	Mardi 4 Mai 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Dimanche 16 Mai 2010	Par	Support France
Thème	Administration des comptes, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.UpdateServeur

Prototype

Function UpdateServeur (IdSite As String, sBase As String) As Integer

Usage
Administration-des-comptes.UpdateServeur(...)
HTTP (GET,POST)	SOAP WSDL	SOAP REST	XML-RPC

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function UpdateServeur (IdSite As String, sBase As String) As Integer

Function UpdateServeur (IdSite As String, sBase As String) As Integer
Dim Ret%
Dim sData$

UpdateServeur = False
'Trigger update

sData = "UPDATE maitre.dbo.XmlServeur SET "
sData = sData + "Maj= '" + Date$ + "',"
sData = sData + "RaisonSociale='" + TabSQLValue(0, 0) + "',"
sData = sData + "Index='" + TabSQLValue(0, 1) + "',"
sData = sData + "Name='" + TabSQLValue(0, 2) + "',"
sData = sData + "PassWord='" + TabSQLValue(0, 3) + "',"
sData = sData + "Adresse='" + TabSQLValue(0, 4) + "',"
sData = sData + "AdresseSuite='" + TabSQLValue(0, 5) + "',"
sData = sData + "Cp='" + TabSQLValue(0, 6) + "',"
sData = sData + "ville='" + TabSQLValue(0, 7) + "',"
sData = sData + "email='" + TabSQLValue(0, 8) + "',"
sData = sData + "phone='" + TabSQLValue(0, 9) + "',"
sData = sData + "fax='" + TabSQLValue(0, 10) + "',"
sData = sData + "XasKey='" + TabSQLValue(0, 11) + "',"
sData = sData + "Host='" + TabSQLValue(0, 12) + "',"
sData = sData + "Enabled='" + TabSQLValue(0, 13) + "',"
sData = sData + "Type='" + TabSQLValue(0, 14) + "', "
sData = sData + "codeenseigne ='" + TabSQLValue(0, 15) + "',"
sData = sData + "Titre ='" + TabSQLValue(0, 16) + "',"
sData = sData + "pays ='" + TabSQLValue(0, 17) + "',"
sData = sData + "langue ='" + TabSQLValue(0, 18) + "', "
sData = sData + "xmluserid ='" + TabSQLValue(0, 19) + "' "
sData = sData + " WHERE Id.xxKey=" + CStr(IdSite)
Ret = pExecute(sData)
If Ret = True Then
    Ret = XasSystemAddAgent(Val(TabSQLValue(0, 1)))
    If TabSQLValue(0, 19) <> "" Then
	sData = "UPDATE XmlUser SET Id='" + CStr(TabSQLValue(0, 1)) + "' WHERE xmluserid.xxKey=" + TabSQLValue(0, 19) + " NOSYNCHRONISATION"
	Ret = pExecute(sData)
    End If
    Ret = XasSystemCreateUser(TabSQLValue(0, 2), TabSQLValue(0, 3), "7", "0111100", sBase)

    UpdateServeur = True
End If

End Function

Références XAS.Technology

Date , Cstr , XasSystemAddAgent , Val , XasSystemCreateUser ,

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.