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

Administration des entités, (Web, Web Services, PDA, WidGet, Fat Client)

Technologie	XAS.Technology	Version	V 6.0.1
Dernière modification	Dimanche 3 Janvier 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Mercredi 13 Janvier 2010	Par	Support France
Thème	Administration des entités, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.UpdateSite

Prototype

Function UpdateSite (sidSite As String) As Integer

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

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function UpdateSite (sidSite As String) As Integer

Function UpdateSite (sidSite As String) As Integer
Dim Ret%
Dim sData$

UpdateSite = False
'Trigger update

sData = " UPDATE Site SET "
sData = sData + "Maj= '" + Date$ + "',"
sData = sData + "RaisonSociale='" + TabSQLValue(0, 0) + "',"
sData = sData + "numCompta='" + TabSQLValue(0, 1) + "',"
sData = sData + "Name='" + TabSQLValue(0, 2) + "',"
sData = sData + "prenom='" + 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 + "Banque='" + TabSQLValue(0, 11) + "',"
sData = sData + "codeenseigne ='" + TabSQLValue(0, 12) + "',"
sData = sData + "Titre ='" + TabSQLValue(0, 13) + "',"
sData = sData + "dep ='" + TabSQLValue(0, 14) + "',"
sData = sData + "region ='" + TabSQLValue(0, 15) + "',"
sData = sData + "pays ='" + TabSQLValue(0, 16) + "',"
sData = sData + "langue ='" + TabSQLValue(0, 17) + "',"
sData = sData + "devise ='" + TabSQLValue(0, 18) + "',"
sData = sData + "NumAgent='" + TabSQLValue(0, 19) + "',"
sData = sData + "Type='" + TabSQLValue(0, 20) + "' "
sData = sData + " WHERE CodeSite.xxKey=" + CStr(sidSite)
Ret = pExecute(sData)
If Ret = True Then
    Ret = CalculRegion(sidSite, "codeSite", "site", TabSQLValue(0, 6))
    UpdateSite = True
End If

End Function

Références Composants

Administration-des-entites-SQLDATA-CalculRegion,

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.