SQL Console (ADT) on Mac

[ptrck]

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

[former_member201346]

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]

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

[former_member201346]

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

[ptrck]

Hi Felix,

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

[former_member232579]

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