Home » SQL & PL/SQL » SQL & PL/SQL » Possible to carry forward information from one record to the next? (Oracle Databse HTML DB)
icon5.gif  Possible to carry forward information from one record to the next? [message #442964] Thu, 11 February 2010 12:55 Go to next message
nik0lla
Messages: 17
Registered: February 2010
Location: Canada
Junior Member
Hi all,

What I'm pretty much dealing with:

It's a checklist for canisters when they have maintenance performed on them. A work order is created, a canister is selected for the work order and the type of evaluation is selected (eg: Overhaul and Repair, Minor Repair etc). The checklist has many items to it and the one I'm primarily focusing on is the "Actuator Manufacturer". This field allows you to check off 1 of 3 choices of manufacturers and then a text box opens up on the side to enter the serial number.

What my boss wants:

He wants to have the value from this field from the last work order created prior to this one to carry forward. That means the manufacturer that they chose from the check boxes and the text from the text box, with the option of changing the information if it doesn't apply anymore.

My Question:

Is this even possible? I don't think it is but I thought I would run it past people with more SQL/Oracle experience than myself.

Thanks a bunch guys.
Re: Possible to carry forward information from one record to the next? [message #442965 is a reply to message #442964] Thu, 11 February 2010 13:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have a look at LAG/LEAD functions.

Regards
Michel
Re: Possible to carry forward information from one record to the next? [message #442967 is a reply to message #442965] Thu, 11 February 2010 13:28 Go to previous messageGo to next message
nik0lla
Messages: 17
Registered: February 2010
Location: Canada
Junior Member
That would work in some cases but I don't think so here.

How this database was created was the table has "cl_desc", "cl_completed" and "cl_comment". The cl_desc is the name of the item in the checklist, so it could be actuator manufacturer, but it could also be current status, canister SIN, etc etc. The cl_comment is the information from the text box, and the cl_completed is the initial of the manufacturer they had chosen. I guess I should have given more detail the first time around, sorry.
Re: Possible to carry forward information from one record to the next? [message #442969 is a reply to message #442967] Thu, 11 February 2010 13:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you post a working Test case: create table and insert statements along with the result you want with these data, we will be able to work with them.
Also always post your Oracle version with 4 decimals.

Regards
Michel
Re: Possible to carry forward information from one record to the next? [message #442970 is a reply to message #442969] Thu, 11 February 2010 13:40 Go to previous messageGo to next message
nik0lla
Messages: 17
Registered: February 2010
Location: Canada
Junior Member
Sorry, here it is: 2.0.0.00.49

I've managed to lock myself out of the system (cleared my history/cookies and such earlier) and lost part of my login... can't get in until tomorrow when my boss gets back in haha so I'll be back I guess.

I appreciate your patience <3
Re: Possible to carry forward information from one record to the next? [message #442971 is a reply to message #442970] Thu, 11 February 2010 13:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Sorry, here it is: 2.0.0.00.49
What is the significance of the line above?
Re: Possible to carry forward information from one record to the next? [message #442972 is a reply to message #442971] Thu, 11 February 2010 13:56 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
BlackSwan wrote on Thu, 11 February 2010 20:45
>Sorry, here it is: 2.0.0.00.49
What is the significance of the line above?


He might be running Oracle Version 2 released 1975 by Relational Software, Inc.
Re: Possible to carry forward information from one record to the next? [message #442989 is a reply to message #442971] Thu, 11 February 2010 21:40 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
BlackSwan wrote on Fri, 12 February 2010 01:15
>Sorry, here it is: 2.0.0.00.49
What is the significance of the line above?


I guess he is saying about
the Quote:
HTML DB version.



It would be helpful if you follow
Quote:
Michel Cadot

If you post a working Test case: create table and insert statements along with the result you want with these data, we will be able to work with them.
Also always post your Oracle version with 4 decimals.


regards
sriram Smile
Re: Possible to carry forward information from one record to the next? [message #443008 is a reply to message #442989] Fri, 12 February 2010 00:47 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
ramoradba wrote on Fri, 12 February 2010 04:40
I guess he is saying about
the Quote:
HTML DB version.


That is no quote.
Re: Possible to carry forward information from one record to the next? [message #443022 is a reply to message #443008] Fri, 12 February 2010 02:08 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
As you are a moderator you can remove that one right?

Don`t know today a bad day for me..from you moderators on my posts.
Posting Non-sence/irrelevant should be consider as non-sence irrespective of "Member" type.


Thanks
sriram Smile
Previous Topic: Auto Generate User Names through particular column (merged by CM)
Next Topic: Matrix report problem
Goto Forum:
  


Current Time: Tue Feb 11 20:19:09 CST 2025