Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Console (ADT) on Mac

ptrck
Explorer
0 Kudos
695

Hi,

I´m using Eclipse Photon (Release 4.8.0)
on a Mac (10.13.6)
with ADT (com.sap.adt.core.devedition.feature.group=2.96.2)

Now my problem: When I use the SQL Console I get this error message:

(Query execution failed
"ROWS" ist im ABAP-Dictionary nicht als Tabelle, Projektions- oder Datenbank-View deklariert worden oder nicht aktiv vorhanden.
select *
from t100)


When I write the SQL Statement in one single line everything works fine:

I guess the problem comes from the different line endings of Win and Mac. A few ideas on how I can fix or work around the problem?

BTW: There are more bugs in ADT on a Mac, but this one bothers me the most.

thanks and greetings
Patrick

1 ACCEPTED SOLUTION

former_member232579
Discoverer
0 Kudos
352

Hi Patrick,

as a short-term workaround you could set the workspace default delimiter to CRLF.

This can be done in the Eclipse Preferences.
Under Preferences>General>Workspace you can find the Setting for "New Text file line delimiter".
If you change this from Default to Other: Windows then Eclipse will use CRLF instead of LF for an empty file.

Other ABAP Source Editors also use CRLF, as you can see with Felix hint to visualize whitespace characters.

This should remove the symptom in the SQL Console for now.

Regards,

Ivo

5 REPLIES 5

former_member201346
Active Participant
0 Kudos
352

Hi Patrick,

I played around a bit with the view (MacOS 10.13.6). There is one thing worth to try: add a space at the end of each line. That's of course no solution, but could be a workaround.

Regards, Felix

ptrck
Explorer
0 Kudos
352

Hi Felix,

thanks for the tip, but unfortunately it doesn't work. Neither with a space nor with a tabulator or with a comment at the end of each line. I think the problem are the different line endings (CRLF, LF) and the transfer to the backend.

Regards, Patrick

0 Kudos
352

Hi Patrick,

I missed your reply and so far I don't have a solution. But there is one new finding.

Just activate the visualization of line endings (Command + 3: type "show white" and select "Show whitespace characters in current editor"). Now open a new SQL console from the Data Preview of a table. The pre-filled statement contains CRLF and it gets additional CRLF when you modify it. But when you remove the whole content and start a new statement from scratch you get LF only. And now you can't execute the statements anymore.

Regards, Felix

0 Kudos
352

Hi Felix,

thanks a lot. I´ll try that tomorrow. Today I´m in home office with citrix.....

former_member232579
Discoverer
0 Kudos
353

Hi Patrick,

as a short-term workaround you could set the workspace default delimiter to CRLF.

This can be done in the Eclipse Preferences.
Under Preferences>General>Workspace you can find the Setting for "New Text file line delimiter".
If you change this from Default to Other: Windows then Eclipse will use CRLF instead of LF for an empty file.

Other ABAP Source Editors also use CRLF, as you can see with Felix hint to visualize whitespace characters.

This should remove the symptom in the SQL Console for now.

Regards,

Ivo