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 17 Janvier 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Jeudi 28 Janvier 2010	Par	Support France
Thème	Administration des entités, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.UpdateEnseigne

Prototype

Function UpdateEnseigne (sid As String) As Integer

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

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function UpdateEnseigne (sid As String) As Integer

Function UpdateEnseigne (sid As String) As Integer
Dim Ret%
Dim sData$

UpdateEnseigne = False
'Trigger for update

sData = " UPDATE maitre.dbo.Enseigne 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 + "Type='" + 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 + "icon='" + TabSQLValue(0, 19) + "' "
sData = sData + " WHERE CodeEnseigne.xxKey=" + CStr(sid)
Ret = pExecute(sData)
If Ret = True Then
    Ret = CalculRegion(sid, "codeenseigne", "Enseigne", TabSQLValue(0, 6))
    UpdateEnseigne = 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.