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.
Query Builder parse error?
Re: Query Builder parse error?
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.
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.