0
 Followers
7
 Likes

Add number of error line

Backend
Not right now

If we has any error in query test, like the image


is a great idea insert the line number to know where is the error, because is not a good comment this mensage.


Please fix that!


Thanks

Created on 2 Jul
Comments (6)

Hi Thiago,

Although I understand the use case, on the technical side this would be hard to achieve. The query executed on the db server is not exactly the same as the code the user has written, for instance table names are replaced by physical table name, therefore the row number is not the same on the editor as on db server. 

Even doing some kind of inteligent parsing algorithm to the error message returned by the db server could be misleading. On your example how many "." do you have?

Depending on the community adoption to this idea we can prioritize research on how can we achieve this kind of functionality.

Thanks for your feedback.


Hi Fernando.


I understand the change of table names, i already made some query directly in "SQL SERVER" using Outsystems Tables. But i think this "feature" not difficult to implement.


I have a simple query with right left's, inner's and right's joins, and i find where i made my mistake, but in other case, i have more than 300 lines in code, and if some error message is difficult to localize the error because the message is not much clear.


Maybe the solution is add a column before the box where i write the code and in message add the line number...


Thanks!

Changed the category to Backend


Changed the status to
Not right now


Hi Thiago,

I get your point, with a complex query could be very difficult to know where the problem is. We will do further research but for the moment I cannot commit to a date.

Let's see how much traction this idea gets from the community.

Thanks,

Hi Fernando,


Thanks for feedback. Just a question, why you put the Idea in "Category Backend" ? If the point is see what the community say about this idea, its better to make is visible?


Thanks

Hi Thiago,

Backend is just the area of the product this Ideas affects. It is still being visible by the community.

Thanks,


views
139
Followers
0