What syntax should I use to specify the WorkArea or TableAlias when using the keyword "DELETED( )" in an implicit inner join query, using your DBF v4.1 driver within ColdFusion.
For example:
SELECT pp.id, dd.leadstatus, cc.task, cc.fudate FROM ConMgmt.prospects pp, ConMgmt.leads dd, ConMgmt.contacts cc WHERE pp.hh = dd.hh and dd.product = cc.product and not deleted(pp)
With the syntax shown here, I am getting an error back from your driver that says 'Invalid nWorkArea or cTableAlias in DELETED(pp).'
Thanks for your help!!
Paul Hall
|
>not deleted(pp)
not deleted('pp')
|
Thanks!!!! Works great. How silly of me that I didn't try that syntax.
Thanks again
|