1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| Function MajTables()
RequeteSQLIns= "SELECT [datep] FROM Absence "
MyLog.WriteLine("Deb Requete => : "+RequeteSQLIns+" "+cstr(Time))
RSIns.Open RequeteSQLIns,Connexion,adOpenForwardOnly,adLockReadOnly
Do While Not RSIns.EOF
code1=trim(RSIns("datep").value )
date_annee=Mid(code1,8,2)
if (date_annee="10") then
date_annee="2010"
end if
date_mois=mid(code1,4,3)
REM wscript.echo " DATE mois "& date_annee
if (date_mois="May") then
date_mois="05"
end if
date_jour=mid(code1,1,2)
code2= date_jour & date_mois & date_annee
RequeteSQLIns = "UPDATE absence SET absence.datep ="&CStr(code2)
wscript.echo CStr(code2)
MyLog.WriteLine("-----------------------------------------------------")
MyLog.WriteLine("transformation de la date=> "+RequeteSQLIns)
RSIns.MoveNext
Loop
RSIns.Close
end Function |
Partager