Ainhoa, Can you please post the entire script? Also try to add --trace option to see which query was actually executed in the database.
Thanks, Dmitry On Tue, Nov 29, 2016 at 11:44 AM, Ainhoa Benitez <abeni...@corenetworks.es> wrote: > Good morning, > > my name is Ainhoa. I am starting to use the HPLSQL tool and up to now it > was working fine. However, my issue has to do when using a simple where > clause, does this tool accept to write a where clause? > > For example, the problem is the following: > > -I have a table named "test" with several fields. I make a select clause > such as: "select * from test limit 3" and it displays the result with no > result. I try to make another query selecting particular fields of the > table and no problem. > > Nevertheless, the issue comes when I try to do some of the following > queries: > > -Select count(*) from test; > > -Select * from test where movieid <5; > > I do not have any idea why the problem keeps occuring or how to solve it. > Is there any possibility to make a query with where conditions? If so, how? > And about count all fields query, what could the problem be? > > Thanks so much for your help!!! > > Ainhoa > > Segun el Articulo 5 de la L.O.P.D, le informamos que sus datos constan en > un fichero titularidad de CORE NETWORKS, S.L., cuya finalidad es la gestion > administrativa. Podra ejercer su derecho de acceso, rectificacion, > cancelacion y oposicion mediante correo postal a C/ Serrano Galvache, 56, > Edificio Olmo, 1 Planta - C.P. 28033 (MADRID), o enviando un correo > electrónico a i...@corenetworks.es. >