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 16 Mars 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Samedi 20 Mars 2010	Par	Support France
Thème	Administration des comptes, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.InsertUser

Prototype

Function InsertUser (sid As String, sBase As String, sBaseref As String) As Integer

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

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function InsertUser (sid As String, sBase As String, sBaseref As String) As Integer

Function InsertUser (sid As String, sBase As String, sBaseref As String) As Integer
Dim Ret%
Dim IdUser%
Dim sData$
Dim s$
Dim screa$

InsertUser = False
s = TabSQLValue(0, 0)
If isUserExist(s) = False Then
    Ret = pExecute("CLEAR")
    sData = " INSERT INTO XmlUser (Creation,maj,Type,Name,password,filename,text,fileperso,"
    sData = sData + "databaseactif,datapredictif,email,phone,fax,enabled,codeClient,byref,profile,method,charte,police,langue,XmlRules) VALUES ("
    screa = Date$
    sData = sData + "'" + screa + "',"
    sData = sData + "'" + screa + "',"
    sData = sData + "'1',"
    sData = sData + " '" + TabSQLValue(0, 0) + "',"
    sData = sData + " '" + TabSQLValue(0, 1) + "',"
    sData = sData + " '',"
    sData = sData + " '" + TabSQLValue(0, 2) + "',"
    sData = sData + " '" + TabSQLValue(0, 3) + "',"
    sData = sData + " '" + TabSQLValue(0, 4) + "',"
    sData = sData + " '" + TabSQLValue(0, 5) + "',"
    sData = sData + " '" + TabSQLValue(0, 6) + "',"
    sData = sData + " '" + TabSQLValue(0, 7) + "',"
    sData = sData + " '" + TabSQLValue(0, 8) + "',"
    sData = sData + " '" + TabSQLValue(0, 9) + "',"
    sData = sData + " '" + CStr(sid) + "',"
    sData = sData + " '" + GlobPU.XasName + "',"
    sData = sData + " '" + TabSQLValue(0, 10) + "',"
    sData = sData + " '" + TabSQLValue(0, 11) + "',"
    sData = sData + " '" + TabSQLValue(0, 12) + "',"
    sData = sData + " '" + TabSQLValue(0, 13) + "',"
    sData = sData + " '" + TabSQLValue(0, 14) + "', "
    sData = sData + " '" + TabSQLValue(0, 20) + "'  )"
    Ret = pExecute(sData)
    If Ret = True Then
	Ret = XasUserGetString(1, TabSQLValue(0, 15))
	IdUser = XasSystemCreateUser(TabSQLValue(0, 0), TabSQLValue(0, 1), TabSQLValue(0, 10), "0111100", sBase)
	If IdUser <> False Then
	    Ret = CopySQLUserPerso(GlobPU.XasName, TabSQLValue(0, 0), sBaseref)
	    InsertUser = True
	End If
    End If
End If


End Function

Références Composants

Administration-des-comptes-SQLDATA-isUserExist, Administration-des-comptes-SQLDATA-CopySQLUserPerso,

Références XAS.Technology

Date , Cstr , XasUserGetString , 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.