Devart Forums

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

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?

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