#*************************************************************
# MacDescription = Attribute list AND Mfilter example
# MacFileName = attrib.gsk
# Original from http://gsak.net/board/index.php?showtopic=14047&st=0&#
# MacVersionAuthor = GeoFlowers
# MacVersion = 1.1
# MacUrl= http://www.wandelverhalen.com/gps/gsak/macros.php
#*************************************************************
# Deze macro regels geven een lijst van beschikbare "Attributes"
$File=$_ExePath + "\static.db3"
$_sql="Attach '$File' as GSAKDB"
$Attach=Sqlite("sql",$_sql)
$_sql="Select vTo as Attribute,Vfrom as ID from lookup Where type='attributes' order by vto"
$AttTable=Sqlite("sql",$_sql)
$AttTable="Attribute;ID #"  + $_NewLine + $AttTable
$Out=SqlToHtml($AttTable,"Attribute List","Y")

# Met Mfilter is een database filter te maken op attributes

# In woorden of ID #
Mfilter where= Code IN (select distinct acode from attname where acode = code and aname in ('Boat','Front Yard (Private Residence)')  and aInc)
# Mfilter where= Code IN (SELECT DISTINCT aCode FROM attributes WHERE aID IN (4,65) AND aInc)