Dataset Error in Knowage 7.0

Question

We are having error in creating dataset in knowage 7.0. when we were using declaration in our query. please see 

Answer 1

Dear

For security reasons,  Knowage checks the SQL statement in order to verify if contains only select statements.

What type on sql did you write ?

Best Regards

A

Comments

Hi Angelo,

it's the same query i used in 6.4.4 version and its working. why in 7.0 is not, is the checking of sql query for security reason is the new features of 7.0? also Stored procedure has the same error when running in 7.0 version.

---

Hi,

In some case we have added some constraints on 7.

Could you write me the sql statements, and check inthe knowage.log file for more details.

Best regadrs

Angelo

Answer 2

I faced the same issue.
Error was thrown because the query started with a comment

-- comment...
select ...

Comments

Hi,

you can put set nocount on; in your query

-:D:D