hi,
We have problems with ESQL queries to view. It gives error when generating a query that uses a LIKE and ORDER BY with LIMIT and SKIP. We realized that the error occurs when applying to LIKE NOT NULL fields.
SELECT VALUE VCLIENTESBUSQUEDA FROM ModeloCliente.VCLIENTESBUSQUEDA as VCLIENTESBUSQUEDA
WHERE VCLIENTESBUSQUEDA.CODCLIENTE LIKE @valor0
ORDER BY VCLIENTESBUSQUEDA.CODCLIENTE ASC SKIP @skip LIMIT @limit
@valor0= cv003%
best regards,
________
Mexico Hotels
ESQL, like, limit and skip!!
ESQL, like, limit and skip!!
Last edited by ies on Thu 24 Feb 2011 06:06, edited 1 time in total.