'Use an SQL statement to retrieve all customers with a Dutch address
Set
Frm = IsahObjects.Get(
"InfoFormObject"
)
Frm.SQL =
"Select CustId, CountryCode, Name, Addr, PostCode, City, Phone "
& _
"From T_CustomerAddress Where CountryCode = 'NL' Order By Name"
Frm.KeyField =
"CustId"
Frm.Caption =
"Customers with an address in the Netherlands"
Frm.ShowModal
Set
Frm = Nothing