Autoselect bug

[mike]

It seems like if the semicolon is on a line alone, auto select doesn't work? I'm using version 7.1.3.1381

For example

SELECT * FROM ben_prtt_enrt_rslt_f bperf
WHERE person_id = 1234
--AND   trunc(SYSDATE) BETWEEN bperf.effective_start_date AND bperf.effective_end_date
--AND   bperf.enrt_cvg_thru_dt = to_date('31-dec-4712', 'dd-mon-yyyy')
AND   bperf.pl_id = 34
--AND   bperf.prtt_enrt_rslt_stat_cd IS NULL
;

SELECT ppx.*
FROM per_people_x ppx
WHERE  full_name LIKE 'Somebody%';

If I place my cursor on the second SQL, I get an invalid SQL error. If I change the first SQL and have the semi-colon a different place, and place my cursor on the second SQL, it works fine.

 

[Marco Kalter]

It works fine for me. Can you send me the exact script as attachment by e-mail?

 

[mike]

Well, it works for me now too. If I see it again, I'll work harder to make sure I can reproduce it.