You got it. You were right about the recursion. Thanks for showing me
how to work around it. I wonder why it worked for the select command,
though.
Lawrence Lustig wrote:
whval1 = boro park
wheres = WHERE contacts.CONTACT_DATE IS NOT NULL
full_where = where AGENCY_NAME cont .whval1 and ID
in (select id from
contacts &wheres)
EDIT USING AgencyWAbbrevHist &full_where ORDER BY
agency_name
I get -Error- Syntax Error (2367)
I would be surprised if R:Base performed recursive
macro substitution on the FULL_WHERE variable. Try:
SET VAR Full_Where = +
'WHERE Agency_Name CONT .whVal1 AND ID IN
(SELECT ID FROM Contacts' & .WhereS + ''''
and then try it.
--
Larry
--
Kayza Kleinman
Director, Nonprofit Helpdesk
Jewish Community Council of Greater Coney Island, Inc.
3001 West 37th Street
Brooklyn, NY 11224
Tel. 718 449-5000
Fax 718 946-8240
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.nphd.org <http://www.nonprofithelpdesk.org/>
“Putting Technology to Work For You”
