2

I had a sql that had some error. Although the error says

SQL Error [42601]: ERROR: syntax error at or near "from"
  Position: 420

. However, it seems dbeaver didn't highlight exactly where the error is. It tells me it is position 420, but i don't know where is position 420 intuitively....

Is it possible to let DBeaver to highlight error for me.

PS: I could identify the error by eyeballing this time... but other times seem difficult...

enter image description here

hg628193hg
  • 33
  • 6

2 Answers2

0

In this case, your problem is you have a comma at the end of db4_open, right before the FROM clause. Remove that comma and the query will not have that error. Some query GUIs have the ability in an Options page to turn on line numbers. Not sure if that is the case for this tool or not.

Lee M
  • 352
  • 2
  • 9
-1

enter image description here

I think, just turn on the "Show line numbers" in preferences

clid saniny
  • 1