Toad World® Forums

Query results are refreshed when they should not be.


#1

SQL NAV 7.1

create two tables

– Start of DDL Script for Table T54DB16.B
– Generated 06-Feb-2015 10:31:57 from T54DB16@SSDEV.WORLD

CREATE TABLE t54db16.b
(id NUMBER(*,0) ,
b1 VARCHAR2(25))
SEGMENT CREATION IMMEDIATE
TABLESPACE users
NOPARALLEL
LOGGING
MONITORING
/

– Constraints for T54DB16.B

ALTER TABLE t54db16.b
ADD PRIMARY KEY (id)
USING INDEX
TABLESPACE users
/

– End of DDL Script for Table T54DB16.B

– Start of DDL Script for Table T54DB16.A
– Generated 06-Feb-2015 10:31:42 from T54DB16@SSDEV.WORLD

CREATE TABLE t54db16.a
(id NUMBER(*,0),
a1 VARCHAR2(25))
SEGMENT CREATION IMMEDIATE
TABLESPACE users
NOPARALLEL
LOGGING
MONITORING
/

– End of DDL Script for Table T54DB16.A

open a new tab and select data from table a

SELECT * FROM t54db16.a ORDER BY 2,1;

open another tab and select data from table b

click on the first tab - you will notice the order is not the same as you originally requested. (order by 2,1)


#2

Hi Henry,

I couldn’t not reproduce the issue. I didn’t see the first result got refreshed after I switched back from the 2nd tab. Could you please send me
the support bundle files(both dta and prof) from Help | Create Support Bundle Files? My email is
vincent.liu@quest.com.

Thanks,

Vincent


#3

Vincent - you did see the refreshed result. Your just not looking hard enough. There is no way you can miss this. Please try again, maybe with a little more data. The results from the first query (select * from .

order by 2,1