Posted 7 years ago by John Smith
Version: 2.5.16
Avatar

I actually have version v2.6 on Windows 10.

When writing SQL, the automatic formatting recognizes the following JOIN Types and colors them blue

FULL

INNER

 

but it does not recognize 

LEFT

RIGHT

 

I have tried the following syntaxes, but have not had any luck.

LEFT OUTER

RIGHT OUTER

LEFT OUTER JOIN

RIGHT OUTER JOIN

LEFT JOIN

RIGHT JOIN

 

Am I missing something? I understand that depending on what type of SQL server you are using, there can be slight differences (I am currently working in an Access database)

 

Thank you!

Comments (1)

Posted 7 years ago by Actipro Software Support - Cleveland, OH, USA
Avatar

Hello,

It actually is coloring them but as an operator and not a keyword.  The operators show up as lighter gray if you are running the app in a light theme. 

These are the words it classifies as an operator in SQL:

ALL AND ANY BETWEEN EXISTS IN LEFT JOIN LIKE NOT OR OUTER RIGHT SOME


Actipro Software Support

The latest build of this product (v4.2.42) was released 3 years ago, which was after the last post in this thread.

Add Comment

Please log in to a validated account to post comments.