Release 10.1A: OpenEdge Development:
ADM Reference

> ## setExternalTableList

> Sets the ExternalTableList property (see `webrprop.i`), a pipe-separated list of comma-separated lists of External Tables that might be used to retrieve data for this request. In report and detail Web objects, this is specified on the External Tables and Objects Page in the QueryBuilder.

> Location: webrep.p

> Parameters:

> `INPUT pcExternalTableList AS CHARACTER`

> A pipe ( | )-separated list of comma-separated tables.

> Returns: LOGICAL

> Notes: The ExternalJoinList and ExternalWhereList and/or ForeignFieldList have corresponding entries.

> Examples:

>     /* If you have a report of orders called reord.html you might call that
>        report from any of the following types of objects:
>        objects that provide ExternalTables=customer in the URL, along with
>        information (rowid or foreign fields) that allow this report to
>        retrieve only orders for a particular customer.
>        objects that provide ExternalTables=salesrep,customer in the URL,
>        along with information (rowids or foreign fields) that allow this
>        report to retrieve only orders for a particular customer sold by a
>        particular salesrep.
>        objects that provide ExternalTables=salesrep in the URL, along with
>        information (rowid or foreign fields) that allow this report to
>        retrieve only orders sold by a particular salesrep.
>        To allow external joins from any of these types of web objects, you
>        would use the following call to setExternalTables: */
>        setExternalTableList(’customer|salesrep,customer|salesrep’).
>     /* setForeignFieldList, setExternalJoinList and setExternalWhereList have
>        corresponding pipe-delimited entries such as the following: */
>     setExternalJoinList
>        (’OF customer|Order.CustNum = Customer.CustNum AND
>        Order.salesrep = Salesrep|Order.salesrep = Salesrep’).
>        setForeignFieldList (’custnum|salesrep,custnum|salesrep’).
>        setExternalWhereList(’|Order.PromiseDate < 12/12/99|’)

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095