How to embed an AutoSearch field in a 'manually-written' query

rbuser

Greetings:

I have a client who has the need for a report which relies on a query such
as:

Select Person_ID from Clients where Person_ID not in (Select Person_ID from
Deliveries where...)

which I don't think can be done using the RAP query designer. Is it possible
to embed an AutoSearch field into a query which is created when the 'Edit
SQL' option is chosen? I've seen examples for doing this, but they require a
pass-through function. That would require creating a new executable for this
client, and I'm hoping there's a shortcut such as identifying the AutoSearch
field ala parameters in a Delphi query.

Phil Frank

nardmoseley

With ReportBuilder 7.03, the DADE Query Designer enables a search condition
to contain a subselect. Acess the Search tab of the Query Designer, add the
Person_ID field, choose the Not in List operator, and then for the search
Value, type the subselect.

--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com