Hello,

I'm trying to interface to Sage's ACT!. Yeah, woe is me.

Anyways. There are some fields in there that look like: CONTACT OPPORTUNITY CONTACTID

Obviously, this confuses me, but I figured I'd try to SQL it anyways with ADO.

cSQL = [select * from VRP_CONTACT where CONTACT CONTACTID = "] + crsrs.contact_opportunity_contactid + ["]

This confuses ADO too, so I'm not alone.

I tried using just contactid and contact_contactid.

Nothing seems to go. Any ideas?