Previous Topic

Next Topic

Inhoudsopgave

Book Index

SQL Property Code Snippet

'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