Home » Developer & Programmer » Forms » Convert repeating record to one record
Convert repeating record to one record [message #351711] Thu, 02 October 2008 12:27 Go to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi,

Done a bit of research on this already, but not sure if I'm heading in the right direction. I have table with repeating record for one person. Now I have to create a record for that person in new table and the entire repeating field of old table will show in one report. For example:

Old table
Ali 1234vv
Ali 3459HH
Ali 8767LL
Ali 2030BB

This should be convert to as one record

Ali 1234vv 3459HH 8767LL 2030BB

Please advice. I oracle has Function for that.

Thanks in advance.
Re: Convert repeating record to one record [message #351754 is a reply to message #351711] Thu, 02 October 2008 19:12 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Does the new table have a single field or multiple fields?

Why have a new table at all? You could make the concatenated string on the fly or use a 'view' to present it. This would be much less work than trying to maintain the data in the two tables. You have to be able to handle deletes as well as inserts.

David
Re: Convert repeating record to one record [message #351827 is a reply to message #351711] Fri, 03 October 2008 06:56 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
The new table will have multiple fields. I heart that oracle has some procedure for that. Please advice.

Thanks
Re: Convert repeating record to one record [message #352252 is a reply to message #351827] Mon, 06 October 2008 21:53 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post the table definitions for these two tables.

David
Previous Topic: i want (((audit.fmb FORMS )))
Next Topic: use of collections in forms developer
Goto Forum:
  


Current Time: Thu Dec 08 18:01:16 CST 2016

Total time taken to generate the page: 0.11572 seconds