The executeQuery method must return a result set

One Star

The executeQuery method must return a result set

Hi everybody,
I'm sorry to create a new post but I can't find an answer to my problem.
I have a tMSSqlInput with a query.
When I run the query I have the following error message:
"Exception in component tMSSqlInput_5
java.sql.SQLException: The executeQuery method must return a result set.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:488)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
(...)"
However if I run my query with Microsoft Sql Server Management Studio I get my results so, i don't know what to do...
If someone can help me i'll be great!!
Thanks!!
Seven Stars

Re: The executeQuery method must return a result set

It seems that the SQL statement in tMSSqlInput_5 is an action (e.g. UPDATE, DELETE, INSERT) and not a SELECT query. To perform direct actions statements you should use tMSSqlRow.
One Star

Re: The executeQuery method must return a result set

Thanks alevy for your help...it's perfect answer.
Regards--->D