Tengo un procedimiento que me filtra datos,
- Code: Select all Expand view
- SELECT
f.id AS c1,
f.cf AS c2,
f.idsucursal AS c3,
f.numerofactura AS c4,
f.data AS c5,
c.id AS c6,
c.sucursal AS c7,
c.codicefiscale AS c8,
c.denominazione AS c9,
c.indirizzo AS c10,
c.cap AS c11,
c.comune AS c12,
c.provincia AS c13,
c.nazione AS c14,
c.telefono AS c15,
c.estado AS c16,
fi.idfactura AS c17,
fi.inf_c AS c18,
fi.inf_p AS c19,
fi.avv_c AS c20,
fi.avv_p AS c21,
fi.zan_c AS c22,
fi.zan_p AS c23,
fi.pblindata_c AS c24,
fi.pblindata_p AS c25,
fi.pinterna_c AS c26,
fi.pinterna_p AS c27,
de.idfactura AS c28,
de.descrizione AS c29,
f.iva AS c30,
f.imponible AS c31,
f.iva AS c32,
f.totaleiva AS c33,
f.totalefattura AS c34,
f.sconto AS c35,
f.totalecliente AS c36
FROM tbfacturas f
Left join tbclientes AS c
ON f.cf = c.codicefiscale
Left join tbinfissi AS fi
ON fi.idfactura = f.id
Left join tbfacturasdes AS de
ON de.id = f.id
WHERE c.denominazione LIKE CONCAT( '%', cwhere, '%' )
ORDER BY f.numerofactura DESC
ENDTEXT
Si este procedimiento lo llamo desde mi app de esta manera:
- Code: Select all Expand view
::oQry:setfilter( cCampo )
::oqry:gotop()
::oBrw:refresh()
lo que estaria enviando en "ccampo" es (comprobado con "fwdbg ccampo"
- Code: Select all Expand view
- c9 like '%F.L.%'
y si hago esto:
- Code: Select all Expand view
- ::oQry:setfilter( "c9 like '%F.L.%'" )
me devuelve todo igual, ahora si hago esto otro:
- Code: Select all Expand view
- ::oQry:setfilter( "c9 like '%IMPI%'" )
me devuelve lo que quiero, que seria todo los datos que comienzan con F.L. IMP...
me devuelve no solo lo que busco, sino el. resto tambien (y. no es lo que quiero).
PERO si lo ejecuto desde HEIDI me devuelve correctamente lo que quiero y debería de devolver.
que estoy haciendo mal?
Para mi el problema lo hace el "punto" porque si pongo s.r.l. no. encuentra (pero hay) en cambio si pongo SRL encuentra (que tambien hay)
