ESQL, like, limit and skip!!

ies · Post by **ies** » Mon 11 Jan 2010 07:46

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

AndreyR · Post by **AndreyR** » Wed 13 Jan 2010 11:18

I have made some tests with the described scenario and everything succeeded.
Could you please send me the script of the table the problem is reproducible on?

ies · Post by **ies** » Mon 18 Jan 2010 10:20

Hi Andrey
I sent the script to your email.
Thanks
________
Hot Box Vaporizers