When in doubt, or curious, RIGHT CLICK!

ScottMattes

Member³
Can't say it too much, right click!

Point to something and right click.

Hilight things and right click.

Just RIGHT CLICK it!
 
and...

You have simple query (in sql window):

select t.*, t.rowid from a t

in current schema only table "a" exists.

and now place the cursor in different places and right click:

1) when you place cursor "|" after the first "t":
select t|.*, t.rowid from a t

onpopup is called like in BE trace:

2005-03-24 09:37:01 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:37:01 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:37:01 : Opening Popup menu for item: Type=TABLE, Owner=PLTOOLKIT, Name=A, SubObject=

2)
select t.*, t|.rowid from a t

2005-03-24 09:37:54 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:37:54 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=

Popup is not opened for any table object!

3) and 4)

select t.*, t.rowid from a| t
select t.*, t.rowid from a t|

When cursor is after a or last t the onpopup call is similar to first case

... but when in current schema table "t" exists the right click behaviour is little different:

1)

select t|.*, t.rowid from a t

2005-03-24 09:44:36 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:44:36 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:44:36 : Opening Popup menu for item: Type=TABLE, Owner=PLTOOLKIT, Name=A, SubObject=

2)

select t.*, t|.rowid from a t

2005-03-24 09:44:56 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:44:56 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=ROWID
2005-03-24 09:44:56 : Opening Popup menu for item: Type=COLUMN, Owner=PLTOOLKIT, Name=T, SubObject=ROWID

3) and 4)

select t.*, t.rowid from a| t
select t.*, t.rowid from a t|

2005-03-24 10:02:42 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 10:02:42 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 10:02:43 : Opening Popup menu for item: Type=TABLE, Owner=PLTOOLKIT, Name=A, SubObject=

It looks to work ok when you select "t" or "a" character.

And another one case:

Try to select or place a cursor within a "from" keyword (when "t" table exists).

The popup is called for:

2005-03-24 09:54:49 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=
2005-03-24 09:54:49 : Opening Popup menu for item: Type=SQLWindow, Owner=PLTOOLKIT, Name=, SubObject=ROWID
2005-03-24 09:54:49 : Opening Popup menu for item: Type=COLUMN, Owner=PLTOOLKIT, Name=T, SubObject=ROWID

---------------------------------------
Greetings,
Joachim Rupik
 
Back
Top