Toad World® Forums

Problems with SQL Navigator Release 6.1.0.1094


#1

Hello dont know if this has been answered before and it its im sorry.

The problem that i have is when a make queries of the following type:

Example:

Query works fine

Select a.date, b.initial_date, b.final_date
from table.name1 a,
(select initial_date, final_date
from table.name2
) b
where a.date between b.initial_date and b.final_date

It is not necesary with dates the problems but this is just an example, if I run that query that query works just fine but if I have a query like this.

Query does not work.

Select a.date, b.initial_date, b.final_date
from (select date
from table.name1
) a,
(select initial_date, final_date
from table.name2
) b
where a.date between b.initial_date and b.final_date

If I run this query it gives me an error that a right parenthesis is missing and if i run the same query in plus it works fine, if a use sql navigator 5.2 is works fine and so if I use another programs.

For your help thanks.


#2

Hi

I could not reproduce your error with 6.1.1, but I suggest that you try it with 6.2 (there was some problems like that one that were fixed).

(I bet that will be the suggestion from the support team :slight_smile: )

Regards
Filipe Silva


#3

Hi Estuardo,

There are a few known issues in 6.1 regarding the parser. This particular issue was fixed in 6.1.1

Gwen


#4

Thanks for your answers.

Sorry that i han’t marked this thread as answerd lng time ago.