Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: SQL statement across multiple lines?

SQL statement across multiple lines? 2 years 2 weeks ago #16870

  • jenspr
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
Hi there. I am new here.
When I use the database browser and write SQL statement, I found out that I have to keep the statement on one line.
If I break it into multiple lines (for better readability for long statements) it always gives me an error.

Can you help please? Tried the search, but did not find a proper solution.
best regards Jens

Please Log in or Create an account to join the conversation.

SQL statement across multiple lines? 2 years 2 weeks ago #16872

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7572
  • Karma: 33
  • Thank you received: 415
Hi Jen

You have to select(highlight) the statement you wish to execute.
We made a tweak in the latest release if nothing is selected everything will be selected automatically for you

5.3.1.12

+ Improved : Multi-line select statement execution
Mike

Please Log in or Create an account to join the conversation.

SQL statement across multiple lines? 1 year 1 month ago #17888

There's a catch here: the editor cursor must be on the first line or the tweak won't work.
The following user(s) said Thank You: admin, Peter.Jonson

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 268 guests and no members online