Auto refresh

[hbar]

The auto refresh of a query result is a really cool feature. However....if you should lose your connection to the db (as tends to happen over a wireless connection), the refresh keeps going, and failing. So between the barrage of errors thrown by the refresh and the login dialog constantly popping up, you can't ever disable the auto refresh, which further propagates the problem. The only way I've found to get around it is via 3 finger salute.

Maybe can there be a failsafe whereby 5 conseccutive fails disables the auto refresh? Or maybe have the auto refresh check the state of the connection before executing?

Thanks.

 

[Marco Kalter]

We'll fix it!

 

[hbar]

SQL> SELECT count(*)
2 FROM users t
3 where t.class = 'The Man'
4 and t.name = 'Marco Kalter';

COUNT(*)
---------
1

1 row selected.

SQL>

 

[CTzen]

I wonder, what if your count(*) returns 2 or 3 ?-)

 

[hbar]

You don't want to know. Let us never speak of it again.

 

[Marco Kalter]

In that case I am The Men.

 

[hbar]

Not possible. Witness:

SQL>
SQL> SELECT c.table_name, i.column_name
2 FROM dba_constraints c
3 , dba_ind_columns i
4 WHERE 1 = 1
5 AND c.index_name = i.index_name
6 AND c.owner = i.index_owner
7 AND c.constraint_type = 'P'
8 AND i.index_name = 'USER_CLASS_PK';

TABLE_NAME COLUMN_NAME
---------- ------------
USERS CLASS
USERS NAME

2 rows selected.

SQL>

(apologies for the formatting)