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	Mercredi 13 Janvier 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Vendredi 29 Janvier 2010	Par	Support France
Thème	Administration des comptes, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.InsertClient

Prototype

Function InsertClient (Id As Integer) As Integer

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

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function InsertClient (Id As Integer) As Integer

Function InsertClient (Id As Integer) As Integer
Dim Ret%
Dim sData$
Dim s$
Dim screa$
Dim idClient$

InsertClient = False

Ret = pExecute("CLEAR")
screa = Date$

sData = " INSERT INTO Client (CodeEnseigne,Creation,maj,RaisonSociale,CarteId,Name,prenom,Adresse,AdresseSuite,Cp,ville,  "
sData = sData + " email,phone,fax,Banque,"
sData = sData + " enabled,identifiant,designation,matricule,Tpe_Name,Tpe_Secours, "
sData = sData + " Type,CodeProgramme,CodeSite,Titre,dep,region,pays,langue,devise,NumCompta,"
sData = sData + " tpe_statut,tpe_direction,tpe_latitude,tpe_longitude,tpe_speed,tpe_cmd,LastIcon,Lastalarm,LastDesi) VALUES ("
sData = sData + "'" + TabSQLValue(0, 0) + "',"
sData = sData + "'" + screa + "',"
sData = sData + "'" + screa + "',"
sData = sData + "'" + TabSQLValue(0, 1) + "',"
sData = sData + "'" + TabSQLValue(0, 2) + "',"  'carteid
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 + "'" + TabSQLValue(0, 10) + "',"
sData = sData + "'" + TabSQLValue(0, 11) + "',"
sData = sData + "'" + TabSQLValue(0, 12) + "',"
sData = sData + "'" + TabSQLValue(0, 13) + "',"  'enabled
sData = sData + "'" + TabSQLValue(0, 14) + "',"
sData = sData + "'" + TabSQLValue(0, 15) + "',"
sData = sData + "'" + TabSQLValue(0, 16) + "',"
sData = sData + "'" + TabSQLValue(0, 17) + "',"
sData = sData + "'" + TabSQLValue(0, 18) + "',"
sData = sData + "'" + TabSQLValue(0, 19) + "', " 'type
sData = sData + "'" + TabSQLValue(0, 20) + "', " 'codeprogramme
sData = sData + "'" + TabSQLValue(0, 21) + "', "
sData = sData + "'" + TabSQLValue(0, 22) + "',"
sData = sData + "'" + TabSQLValue(0, 23) + "',"
sData = sData + "'" + TabSQLValue(0, 24) + "',"
sData = sData + "'" + TabSQLValue(0, 25) + "',"
sData = sData + "'" + TabSQLValue(0, 26) + "',"
sData = sData + "'" + TabSQLValue(0, 27) + "',"
sData = sData + "'" + TabSQLValue(0, 30) + "',"
sData = sData + "'" + TabSQLValue(0, 31) + "'," 'tpe_statut
sData = sData + "'" + TabSQLValue(0, 32) + "',"
sData = sData + "'" + TabSQLValue(0, 33) + "',"
sData = sData + "'" + TabSQLValue(0, 34) + "',"
sData = sData + "'" + TabSQLValue(0, 35) + "',"
sData = sData + "'" + TabSQLValue(0, 36) + "',"
sData = sData + "'" + TabSQLValue(0, 37) + "',"
sData = sData + "'" + TabSQLValue(0, 38) + "',"
sData = sData + "'" + TabSQLValue(0, 39) + "' )"
Ret = pExecute(sData)
If Ret = True Then
    Ret = XasUserGetString(1, idClient)
    TabSQLValue(0, 28) = idClient
    'Ret = ClientForINSERT(idClient)
    Ret = CalculRegion(idClient, "codeClient", "client", TabSQLValue(0, 7))
    InsertClient = True
End If


End Function

Références Composants

Administration-des-comptes-SQLDATA-CalculRegion,

Références XAS.Technology

Date , XasUserGetString ,

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.