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

Administration des missions, (Web, Web Services, PDA, WidGet, Fat Client)

Technologie	XAS.Technology	Version	V 6.0.1
Dernière modification	Samedi 8 Mai 2010	Par	Zaïr BEZGHICHE
Dernière vérification	Lundi 24 Mai 2010	Par	Support France
Thème	Administration des missions, (Web, Web Services, PDA, WidGet, Fat Client)	Fonction	ALRTBAS.MESSSQLGetOrder

Prototype

Function MESSSQLGetOrder (iRow As Integer, iCol As Integer, iSens As Integer) As String

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

Format de sortie
XML	HTML	TEXT	EXCEL(CSV)

Code Source - développement open source

Function MESSSQLGetOrder (iRow As Integer, iCol As Integer, iSens As Integer) As String

Function MESSSQLGetOrder (iRow As Integer, iCol As Integer, iSens As Integer) As String
Dim sData$
Dim sSens$
MESSSQLGetOrder = ""

If iSens = 1 Then
    sSens = "ASC"
Else
    sSens = "DESC"
End If
If iSens <> 0 Then
    Select Case iCol
        Case 1
            sData = sData + " ORDER By designation.string " + sSens
        Case 2
            sData = sData + " ORDER By phone.string " + sSens
        Case 3
            sData = sData + " ORDER By email.string " + sSens
        Case 4
            sData = sData + " ORDER By tpe_name.string " + sSens
        Case 5
            sData = sData + " ORDER By tpe_name.string " + sSens
    End Select
Else
    sData = sData + " ORDER By designation.string DESC"
End If

MESSSQLGetOrder = sData

End Function

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.