MultiCriteria

[victor Saquicela]

Hi.

I have the following code:

Dim mrc As New CMultiRetrieveCriteria
            Dim c As New Cliente
            Dim f As New Modulos.General.FormaPago.FormaPago
            Dim fe As New Modulos.General.FormaEnvio.FormaEnvio
            mrc.addObjectToJoin(c, Nothing, "")
            mrc.addObjectToJoin(f, c, "ClienteToFormaPago")
            mrc.addObjectToJoin(fe, c, "ClienteToFormaEnvio")
mrc.WhereCondition.addSelectLike("CodigoCliente", "%" + s + "%")
Dim cursor As CCursor
            cursor = mrc.perform

I need add to where clause:

addSelectLike("FormaPago.nombre", "%er%")

I need to compare the second table of the join.

[Richard Banks]

Going from memory here...  You should be able to do it using addSelectLike("f.nombre","%er%").

- Richard.