Query Builder parse error?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
robains
Posts: 13
Joined: Tue 05 May 2015 17:09

Query Builder parse error?

Post by robains » Thu 26 Jul 2018 20:37

I've generated a support ticket but thought I'd ask here also.

I'm getting an "Unable to parse Join. Check correctness of join conditions and avoid nested joins." when I try to switch from Text entry into Query Builder.

I've copy/pasted the same SQL text in SSMS and no problems bringing up the SSMS designer. The query executes correctly in both dbForge and SSMS. It's just dbForge seems to have a SQL parsing problem.

Anyone else run into this and how did you go about trying to resolve?

Cheers, Rob.

alexa

Re: Query Builder parse error?

Post by alexa » Wed 01 Aug 2018 10:37

This appears to be the issue of the server itself.

robains
Posts: 13
Joined: Tue 05 May 2015 17:09

Re: Query Builder parse error?

Post by robains » Wed 01 Aug 2018 17:23

Alexa,

If that were the case then why would SSMS not have a problem with the exact same SQL Text?

I think I did find the problem, it because a Start Page new SQL query doesn't know database context (it knows Server context but not active database), so a copy and paste (even from dbForge's own SQL text generation) doesn't work.

A solution would be for dbForge to generate USE clause in all of it's SQL TEXT ... this would ensure a new Query with a cut and paste operation would get the correct database.

Cheers, Rob.

alexa

Re: Query Builder parse error?

Post by alexa » Fri 03 Aug 2018 09:51

We've replied to you by e-mail on this.

Post Reply