Function Updatexmluser (sIdUser As String, sIdEns As String, userbyRef As String) As Integer
Dim Ret%
Dim sData$
Updatexmluser = False
Ret = XmlUserForUPDATE(TabSQLValue(0, 0), TabSQLValue(0, 3), userbyRef, TabSQLValue(0, 12), TabSQLValue(0, 4))
If Ret = True Then
sData = " UPDATE XmlUser SET "
sData = sData + "Maj= '" + Date$ + "',"
sData = sData + "Name='" + TabSQLValue(0, 0) + "',"
sData = sData + "password='" + TabSQLValue(0, 1) + "',"
sData = sData + "text='" + TabSQLValue(0, 2) + "',"
sData = sData + "fileperso='" + TabSQLValue(0, 3) + "',"
sData = sData + "databaseactif='" + TabSQLValue(0, 4) + "',"
sData = sData + "datapredictif='" + TabSQLValue(0, 5) + "',"
sData = sData + "email='" + TabSQLValue(0, 6) + "',"
sData = sData + "phone='" + TabSQLValue(0, 7) + "',"
sData = sData + "fax='" + TabSQLValue(0, 8) + "',"
sData = sData + "enabled ='" + TabSQLValue(0, 9) + "',"
sData = sData + "profile ='" + TabSQLValue(0, 10) + "',"
sData = sData + "method ='" + TabSQLValue(0, 11) + "',"
sData = sData + "charte ='" + TabSQLValue(0, 12) + "',"
sData = sData + "police ='" + TabSQLValue(0, 13) + "',"
sData = sData + "langue ='" + TabSQLValue(0, 14) + "',"
sData = sData + "XmlRules ='" + TabSQLValue(0, 20) + "' "
sData = sData + " WHERE xmluserid.xxKey=" + CStr(sIdUser)
Ret = pExecute(sData)
If Ret = True Then
Updatexmluser = True
End If
End If
End Function
|