vendredi 14 septembre 2012

Macro pour déterminer la hauteur et le bas dans GSAK

#*******************************************
# MacVersion = 1.0
# MacDescription = Mettre Haut et Bas dans User Data (idem à AttributHautBas).
# MacFileName = HautBas.gsk
# MacUrl =
#*******************************************
SPEEDMODE Status=On
$_sql = "UPDATE Caches SET UserData='H' WHERE (code in (SELECT aCode from AttName WHERE aName='Available during winter' and aInc)) and (UserData<>'H')"
$Remplace = Sqlite("sql",$_sql)
RESYNC
$_sql = "UPDATE Caches SET UserData='B' WHERE (code in (SELECT aCode from AttName WHERE aName='Available during winter' and not aInc)) and (UserData<>'B')"
$Remplace = Sqlite("sql",$_sql)
RESYNC
$_sql = "UPDATE Caches SET UserData='' WHERE (code not in (SELECT aCode from AttName WHERE aName='Available during winter')) and (UserData<>'')"
$Remplace = Sqlite("sql",$_sql)
RESYNC

Cette macro se placera dans la colonne Champs perso 1 (User Data).

Archives du blog

Qui êtes-vous ?

Ma photo
Dolbeau-Mistassini (48° 52.2,- 072° 13.2), Québec, Canada
Retraité de l'enseignement.