Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Carry Forward

546431Nov 6 2007 — edited Oct 29 2010
Hi All

I was just wondering if there is any function out there to carry forward a value onto x number of lines. I am not using version 10 so I am unable to use last_value.

Basically I have a column such as the one shown below. Where ever there is a null value I need to bring down the last value. Any ideas on how to achieve this?

ID COL_A COL_B
1 10 10
2 NULL 10
3 30 30
4 40 40
5 NULL 40
6 NULL 40
7 NULL 40
8 50 50
9 NULL 50
10 60 60

Any help would be great

Michelle

Comments

camickr
I assume you mean JInternalFrame?

Remove the MouseListener from the JInternalFrame: 
JInternalFrame f = frames[0];
BasicInternalFrameUI ui = (BasicInternalFrameUI)f.getUI();
Component north = ui.getNorthPane();
MouseMotionListener[] actions = (MouseMotionListener[])north.getListeners(MouseMotionListener.class);
for (int i = 0; i < actions.length; i++)
	north.removeMouseMotionListener( actions[i] );
843804
I assume you mean JInternalFrame?

Remove the MouseListener from the JInternalFrame: 
JInternalFrame f = frames[0];
BasicInternalFrameUI ui =
(BasicInternalFrameUI)f.getUI();
Component north = ui.getNorthPane();
MouseMotionListener[] actions =
(MouseMotionListener[])north.getListeners(MouseMotionL
istener.class);
for (int i = 0; i < actions.length; i++)
	north.removeMouseMotionListener( actions[i] );
Yup, sorry jinternalframe is what I meant.

Ok that does lock it which is great, the only problem now, is when I click on the internal frame - it initially disappears (you can still find it on the toolbar on the bottom) - but it doesn't remain as the active window (when clicked on) - (I'm putting it inside a JWindow if that affects anything?)
cheers for the help.
camickr
JInternalFrame should be added to JDesktopPane.

How to Use Internal Frames:

http://java.sun.com/docs/books/tutorial/uiswing/components/internalframe.html

If you mean your adding the JDesktopPane to a JWindow, then I don't know what the problem might be I've never tried that.
843804
I've tried putting it in a desktop pane like the following: 
jInternalFrame2.setBounds(0, 0, 600, 500);
jDeskTest.setBounds(0,0,600,500);
jWindowTest.setBounds(200,120,600,500);

jDeskTest.add(jInternalFrame2);
jWindowTest.getContentPane().add(jDeskTest);

BasicInternalFrameUI ui = (BasicInternalFrameUI)jInternalFrame2.getUI();
Component north = ui.getNorthPane();
MouseMotionListener[] actions=(MouseMotionListener[])north.getListeners(MouseMotionListener.class);
for (int i = 0; i < actions.length; i++)
	north.removeMouseMotionListener( actions[i] );

jWindowTest.setVisible(true);
jDeskTest.setVisible(true);
I add all my components to the internalframe, then add it to the desktoppane and then add that to the windowframe...its still giving me the problem I mentioned above...
camickr
I've never seen that behaviour and am not even going to try to guess whats wrong based on the lines of code you posted. If you post a 15 - 20 line demo program the illustrates your behaviour then I might take a look at it.
843804
Well, I'd have to post the whole project, because its going to be hard to emulate my problem in around 15-20 lines of code.
I'll play more, and see if other people have further thoughts or solutions...
cheers
camickr
Well, I'd have to post the whole project, because its going to be hard to emulate my problem in around 15-20 lines of code.
Thats the point. You may or may not be able to emulate the problem.

If you do emulate the problem then you have code to post on the forum.

If you don't emulate the problem then you've proven to yourself that a very simple application works normally. Now the next step is to compare this code with your existing code to see whats different. If you can't see whats different I don't know how you expect use to "guess" what your code looks like.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2007
Added on Nov 6 2007
12 comments
4,639 views