Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)
XAS.Services
  XML Kiosk  
Technologie XAS.Technology Version V 6.0.1
Dernière modification Mercredi 19 Mai 2010 Par Zaïr BEZGHICHE
Dernière vérification Dimanche 6 Juin 2010 Par Support France
ThèmeAdministration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client) Fonction SQLDATA.CopySQLUserPerso

Prototype
Function CopySQLUserPerso (UserSrc As String, UserSQL As String, sBaseref As String)
Usage
Administration-des-lots-de-cartes.CopySQLUserPerso(...)
HTTP (GET,POST)SOAP WSDLSOAP RESTXML-RPC
Format de sortie
XML HTML TEXT EXCEL(CSV)

Code Source - développement open source
Function CopySQLUserPerso (UserSrc As String, UserSQL As String, sBaseref As String)
Function CopySQLUserPerso (UserSrc As String, UserSQL As String, sBaseref As String)
Dim Ret%
Dim IdXml%
Dim s$
Dim sid$
Dim i%
Dim imax%
Dim sData$

Ret = pExecute("SELECT xmluserid FROM " + sBaseref + ".dbo.XmlUser WHERE name='" + UserSrc + "'")
If Ret <> False Then
    sid = OnSQLGetItem(0)
    sData = "SELECT linkcomponent.titre "
    sData = sData + " FROM " + sBaseref + ".dbo.XmlUser," + sBaseref + ".dbo.linkcomponent "
    sData = sData + " WHERE XmlUser.xmluserid.xxkey=" + sid
    sData = sData + " AND linkcomponent.id.xxkey=" + sid
    sData = sData + " AND linkcomponent.Name.string='OLDCHARTE'"
    Ret = pExecute(sData)
    If Ret = True Then
	s = OnSQLGetItem(0)
	Ret = pExecute("SELECT xmluserid FROM XmlUser WHERE name='" + UserSQL + "'")
	If Ret <> False Then
	    sData = "INSERT INTO XmlUser.linkcomponent (id,titre) VALUES('"
	    sData = sData + OnSQLGetItem(0) + "','" + s + "')"
	    Ret = pExecute(sData)
	End If
    End If
    
    sData = "SELECT linkcritere.titre,linkcritere.name,linkcritere.value,linkcritere.type,linkcritere.id,linkcritere.codeclient "
    sData = sData + " FROM " + sBaseref + ".dbo.XmlUser," + sBaseref + ".dbo.linkcritere "
    sData = sData + " WHERE XmlUser.xmluserid.xxkey=" + sid
    sData = sData + " AND linkcritere.codeclient.xxkey=" + sid
    Ret = pExecute(sData)
    If Ret = True Then
	While (Ret = True)
	    TabSQLValue(1, 0) = OnSQLGetItem(0)
	    TabSQLValue(1, 1) = OnSQLGetItem(1)
	    TabSQLValue(1, 2) = OnSQLGetItem(2)
	    TabSQLValue(1, 3) = OnSQLGetItem(3)
	    TabSQLValue(1, 4) = OnSQLGetItem(4)
	    TabSQLValue(1, 5) = OnSQLGetItem(5)
	    Ret = InsertLinkCritere(UserSQL)
	    Ret = pMoveNext(0)
	Wend
    End If
End If



End Function

Références Composants
Administration-des-lots-de-cartes-SQLDATA-InsertLinkCritere,

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.


XAS Services - Zaïr BEZGHICHE - Copyright 1991-2011 tous droits réservés- Powered by XAS.Technology