OraFAQ Forum: Forms » Convert repeating record to one record

Home » Developer & Programmer » Forms » Convert repeating record to one record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Convert repeating record to one record [message #351711]

Thu, 02 October 2008 12:27

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.

Report message to a moderator

Re: Convert repeating record to one record [message #351754 is a reply to message #351711]

Thu, 02 October 2008 19:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator