topic Re: SQL Console (ADT) on Mac in Application Development and Automation Discussions

SQL Console (ADT) on Mac

ptrck — Thu, 20 Sep 2018 12:29:14 GMT

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

Re: SQL Console (ADT) on Mac

Former Member — Tue, 02 Oct 2018 11:15:42 GMT

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

Re: SQL Console (ADT) on Mac

ptrck — Mon, 08 Oct 2018 12:26:45 GMT

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

Re: SQL Console (ADT) on Mac

Former Member — Mon, 12 Nov 2018 14:59:59 GMT

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

Re: SQL Console (ADT) on Mac

ptrck — Mon, 12 Nov 2018 15:03:46 GMT

Hi Felix,

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

Re: SQL Console (ADT) on Mac

former_member232579 — Tue, 13 Nov 2018 08:25:47 GMT

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