1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
method run(var eventInfo Event)
var
itemNameSQL SQL
ViewName tableview
db database
endVar
db.open (":work:")
itemNameSQL =
SQL
SELECT DISTINCT CustNo, Company, Addr1, Addr2, City, State, Zip, Country, Phone, FAX, TaxRate, Contact, LastInvoiceDate
FROM ":DBDEMOS:customer.db"
WHERE
(CustNo >= 2100.0)
AND (CustNo <= 2500.0)
ORDER BY CustNo, Company, Addr1, Addr2, City, State, Zip, Country, Phone, FAX, TaxRate, Contact, LastInvoiceDate
endSQL
executeSQL(db, itemNameSQL, ":work:MaTable.DB")
ViewName.open(":work:MaTable.DB")
endMethod |
Partager