topic Re: New SQL syntax and ABAP editor highlighting in Application Development and Automation Discussions

New SQL syntax and ABAP editor highlighting

jrgkraus — Tue, 23 Aug 2016 15:29:43 GMT

Hello to all,

today I read about then new SQL syntax that came with ABAP 740 SP08. Playing around with it, I noticed that the editor seems to detect a syntax error here:

Nevertheless, the syntax is OK. Is this a known issue?

Re: New SQL syntax and ABAP editor highlighting

raphael_almeida — Tue, 23 Aug 2016 15:36:49 GMT

Hi Jorg!

The error is in how you position the mt_tvuvs data structure, the correct is it is before or after the "FROM"

BR,

Raphael Pacheco.

Re: New SQL syntax and ABAP editor highlighting

jrgkraus — Tue, 23 Aug 2016 15:39:52 GMT

Hello Raphael,

the new SQL syntax recommends to put the INTO statement at the end. See http://scn.sap.com/community/abap/blog/2014/10/08/abap-news-for-740-sp08--open-sql for further explanations.

Re: New SQL syntax and ABAP editor highlighting

raphael_almeida — Tue, 23 Aug 2016 15:54:31 GMT

Really, for me also is marked as syntax error, but I can successfully activate the program.

I have on my system the SAP_ABA component 740 0012.

*Stranger things*

Re: New SQL syntax and ABAP editor highlighting

retired_member — Tue, 23 Aug 2016 16:06:43 GMT

Yes, the INTO should be the last clause now ...

Syntax coloring in the WB is done by SAP GUI. You need a recent one. Same for ADT. As soon as my tool buddies learn, that there is a new syntax, they adjust the coloring.

Imagine how it looks when I start testing new things ...

Re: New SQL syntax and ABAP editor highlighting

jrgkraus — Wed, 24 Aug 2016 06:51:17 GMT

I just installed 740 patch 9 - still not working. So the "recent one" you mentioned is not yet released, i guess?

Re: New SQL syntax and ABAP editor highlighting

retired_member — Wed, 24 Aug 2016 07:00:39 GMT

I have

SAP Logon für Windows

740 Final Release

7400.3.9.1125

1676784

and ...

Unfortunately the coloring guy is in vacation, so I cannot ask him, if there's a connection with a kernel patch.

But I'll ask the Open SQL guy ...

Re: New SQL syntax and ABAP editor highlighting

vonglan — Wed, 24 Aug 2016 07:20:48 GMT

I have the same syntax highlighting color problem for INTO in the new SQL syntax. Both in SAPGUI and in Eclipse, and it also concerns PACKAGE SIZE:

Release etc for me:

Backend: 740 SP 10

SAPGUI:

(I did not create a ticket, because I assumed someone at SAP must have already noticed this.)

Would be nice to have this solved.

Thanks,

Edo

Re: New SQL syntax and ABAP editor highlighting

SuhaSaha — Wed, 24 Aug 2016 07:29:19 GMT

Unfortunately the coloring guy is in vacation

the INTO should be the last clause now ...

But the "stricter" SQL-syntax check doesn't check it, does it? I have been using the "new" SQL-syntax for quite sometime but the compiler never complained to me about the position of the INTO-clause

Re: New SQL syntax and ABAP editor highlighting

retired_member — Thu, 25 Aug 2016 09:49:03 GMT

Well then, after asking around, the issue is known but wasn't published.

Because of your discussion entry, we have SAP Note 2359360 now (translation pending) that says:

It (in fact) is a Kernel error that is resolved with Kernel 745.

Cheers

Horst

PS: seems that SCN is evolving into a kind of ABAP hotline (and I'm the hotliner ) ...

Re: New SQL syntax and ABAP editor highlighting

retired_member — Thu, 25 Aug 2016 09:56:50 GMT


But the "stricter" SQL-syntax check doesn't check it, does it?

It should.

See Strict Mode 7.50.

If you fulfill one of the requirements for the strict mode listed there and it doesn't, we have another error, either in the kernel or the documentation (maybe some conditions were removed but the documentation was not informed ...).

Re: New SQL syntax and ABAP editor highlighting

SuhaSaha — Thu, 25 Aug 2016 10:47:18 GMT

Hi Horst,

I forgot to mention that i'm working on ABAP740 SP12. I guess in this release the position of the INTO-clause is not "strictly" checked.

BR,

Suhas

Re: New SQL syntax and ABAP editor highlighting

retired_member — Thu, 25 Aug 2016 10:52:25 GMT

No, 't came too late in that release.