XAS, Xml Server, Xml Services, XML Kiosk, Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)

Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)

Technologie	XAS.Technology	Version	V 6.0.1
Dernière modification	Dimanche 21 Mars 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Lundi 29 Mars 2010	Par	Support France
Thème	Administration des lots de cartes, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	SQLDATA.InsertTransac

Prototype

Function InsertTransac (typeMetier As Integer) As Integer

Usage
Administration-des-lots-de-cartes.InsertTransac(...)
HTTP (GET,POST)	SOAP WSDL	SOAP REST	XML-RPC

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function InsertTransac (typeMetier As Integer) As Integer

Function InsertTransac (typeMetier As Integer) As Integer
Dim Ret%
Dim sData$
Dim IdEns%
Dim idProg%
Dim IdSite%

Ret = pExecute("CLEAR")
sData = "SELECT CodeEnseigne,CodeProgramme,Codesite FROM Client WHERE Codeclient.xxKey = " + TabSQLValue(0, 0)
Ret = pExecute(sData)
If Ret Then
    IdEns = Val(OnSQLGetItem(0))
    idProg = Val(OnSQLGetItem(1))
    IdSite = Val(OnSQLGetItem(2))
End If
Ret = pExecute("CLEAR")
Select Case typeMetier
Case 6
    sData = " INSERT INTO Transaction (CodeEnseigne,CodeClient,CodeProgramme,CodeSite,Creation,maj,Name,numCompta,NumSerie,NumMaitre,NumAgent,OSVersion,memorysize,AdresseIp,"
    sData = sData + " numpad,numhost,hostdata,hostkey,hostheure,hostappel,type,hardmode,hardreseau,position,idhardassoc,onprog,onpv)  VALUES ("
    sData = sData + " '" + CStr(IdEns) + "',"
    sData = sData + " '" + TabSQLValue(0, 0) + "',"
    sData = sData + " '" + CStr(idProg) + "',"
    sData = sData + " '" + CStr(IdSite) + "',"
    sData = sData + "'" + Date$ + "',"
    sData = sData + "'" + Date$ + "',"
    sData = sData + " '" + TabSQLValue(0, 1) + "',"
    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 + " '" + 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, 15) + "',"
    sData = sData + " '" + TabSQLValue(0, 16) + "',"
    sData = sData + " '" + TabSQLValue(0, 17) + "',"
    sData = sData + " '" + TabSQLValue(0, 18) + "',"
    sData = sData + " '" + TabSQLValue(0, 19) + "',"
    sData = sData + " '" + TabSQLValue(0, 20) + "',"
    sData = sData + " '" + TabSQLValue(0, 21) + "' ) "
    Ret = pExecute(sData)
    If Ret = True Then
	'ret=TransactionForINSERT(idTransac)
	InsertTransac = True
    End If
End Select

End Function

Références XAS.Technology

Val , Cstr , Date ,

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.